[RESOLVED]Refreshing A DataGrid

[Roofuss]

Hi

I have my main form which has a "New Customer" button on it and a DataGrid

when you click the "New Customer" Button it opens up a new form where you can add all the detials in and press save then the data is saved into SQL database.

can anyone tell me how to refresh my datagrid upon closing this form? as the as at the moment the data from my SQL database is loaded in when the form loads(program starts) using the code below

CODE]Me.CustomersTableAdapter.Fill(Me.MySoftwareDB.customers)[/CODE]

Thanks

[jmcilhinney]

There should be no need to refresh anything. The data should be added to the grid first, then saved. First, you populate a DataTable and bind it to your grid to display the data. When the user adds a new record you should be adding a new row to that DataTable first, which will automatically show up in the bound grid. You then save the changes in the DataTable back to the database using the very same TableAdapter that you populated it with in the first place.

[Roofuss]

There should be no need to refresh anything. The data should be added to the grid first, then saved. First, you populate a DataTable and bind it to your grid to display the data. When the user adds a new record you should be adding a new row to that DataTable first, which will automatically show up in the bound grid. You then save the changes in the DataTable back to the database using the very same TableAdapter that you populated it with in the first place.

Hi Thanks for the reply

I think i understand however when i am adding a new customer i am not adding it directly onto the grid im adding it through my my addCustomer form. all the grid does is display the the information i have added. however at the moment the only way i can see new entries is if i close the program down and start it again because the information for the datagrid gets imported at load time. i want it to appear straight after i have close my addCustomer form.

Any ideas?

[jmcilhinney]

There's no reason your user interface has to change. Your main form displays the grid. The user clicks a button or whatever and a dialogue is displayed where they enter the data for a new record. When that dialogue closes the main form retrieves the data from the dialogue and adds it to the data that it's displaying in the grid, which it then saves. The user sees exactly the same workflow but your application follows the "proper" way of doing things.

[Roofuss]

There's no reason your user interface has to change. Your main form displays the grid. The user clicks a button or whatever and a dialogue is displayed where they enter the data for a new record. When that dialogue closes the main form retrieves the data from the dialogue and adds it to the data that it's displaying in the grid, which it then saves. The user sees exactly the same workflow but your application follows the "proper" way of doing things.

Thanks so would how i achieve this? would you simply write a query to update the table upon closing the dialog? if so how? im a massive time noob to sql

[jmcilhinney]

You use the very same TableAdapter you used to get the data in the first place. You simply call Update instead of Fill. You can do that each time the user adds a record if you need to but once when you close the grid form is likely enough.

[Roofuss]

You use the very same TableAdapter you used to get the data in the first place. You simply call Update instead of Fill. You can do that each time the user adds a record if you need to but once when you close the grid form is likely enough.

Sorry i tried that and its still not working is says that:

Me.CustomersTableAdapter.Update(Me.MySoftwareDB.customers) does not belong to my dialog form i've tried to call it as a sub but still doesnt work?

if you were going to put it on my form below how would you write it?

Imports System.Data.SqlClient
Imports System.Data



Public Class frmCustomer
    Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
        'GETS COONECTION STRING FROM THE MSDN FORM/CLASS
        Dim Connection As SqlConnection = MSDB.GetConnection
        'DOES THE CONNECTION TO THE SQL DATABASE
        Dim mySqlCommand As SqlCommand = New SqlCommand
        Connection.Open()
        ' WHILE THE CONNECTION IS OPEN
        mySqlCommand.Connection = Connection
        'INSERT THE FOLLOWING DETAILS FROM THE TEXT BOXES ON THE CURRENT FORM INTO THE CUSTOMER TABLE  IN THE SQLDATABASE CALLED MYSOFTWAREDB
        Try
            mySqlCommand.CommandText = "INSERT INTO customers (CustomerID, Customer, Contact, Email) VALUES (@CustomerID, @Customer, @Contact, @Email)"
            mySqlCommand.Parameters.AddWithValue("@CustomerID", tbCustomerID.Text)
            mySqlCommand.Parameters.AddWithValue("@Customer", tbCustomer.Text)
            mySqlCommand.Parameters.AddWithValue("@Contact", tbContact.Text)
            mySqlCommand.Parameters.AddWithValue("@Email", tbEmail.Text)
            mySqlCommand.ExecuteNonQuery()
            'IF THE QUERY IS SUCCESSFULL THEN SHOW MESSAGE BOX BELOW
            MessageBox.Show("New Customer Added and Database Updated.", "Accepted", MessageBoxButtons.OK, MessageBoxIcon.Information)
            'IF THE QUERY IS NOT SUCCESSFULL THEN SHOW THIS MESSAGE BOX BEOW THAT CONTAINS THE ERROR MESSAGE
        Catch ex As Exception
            MessageBox.Show("Customer could not be added: " & ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
            'FINALLY CLOSE THE CONNECTION IF ITS STILL OPEN 
        Finally
            If Connection.State = ConnectionState.Open Then
                Connection.Close()
            End If
        End Try
        'THEN CLOSE THE FORM AND RETURN TO FRMMAIN.
        Close()
    End Sub

End Class

any ideas this is really stressing me out lol

[jmcilhinney]

As I've already said, you don't save the data in the dialogue. You save it in the main form.

[Roofuss]

so are you saying to take the code from my save button and place it in my main form then call the procedure in my save button?

[MalodicOne]

This may help,

http://www.vbforums.com/showthread.php?t=561829

Also, it may cause you issues using a querey to insert the data into the backend, you should let the datagrid take the info and insert it, it may cause redundency errors.

[MalodicOne]

This code is placed in the "Main Form" on a toolstrip label:

Private Sub ToolStripLabelProc_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ToolStripLabelProc.Click

        If AddProc.ShowDialog() = Windows.Forms.DialogResult.OK Then
            With ProcessorComboBox
                .DisplayMember = "Processor"
                .ValueMember = "Processor"
                .DataSource = GetList("Processors", "Processor")
            End With
        End If
    End Sub

Upon clicking that label it opens another form to allow the client to enter a new proc type, the following code is in the new form inside the 2 command buttons on the form:

Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click

        Me.DialogResult = Windows.Forms.DialogResult.OK

    End Sub

    Private Sub btnCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCancel.Click

        Me.DialogResult = Windows.Forms.DialogResult.Cancel

    End Sub

[N2DFIRE]

There's no reason your user interface has to change. Your main form displays the grid. The user clicks a button or whatever and a dialogue is displayed where they enter the data for a new record. When that dialogue closes the main form retrieves the data from the dialogue and adds it to the data that it's displaying in the grid, which it then saves. The user sees exactly the same workflow but your application follows the "proper" way of doing things.

Roofuss

The best way is like jmcilhinney is suggesting, but what you are doing. It might work if you put the code that you are using to fill your datagrid in your form_load event, in the form_activated event instead, it will trigger when you go back to your main form with the datagrid. I believe a simply fix, but not the best way of doing things! If I understand your first post that the datagrid is populated in the forms_load event.

[Roofuss]

Roofuss

The best way is like jmcilhinney is suggesting, but what you are doing. It might work if you put the code that you are using to fill your datagrid in your form_load event, in the form_activated event instead, it will trigger when you go back to your main form with the datagrid. I believe a simply fix, but not the best way of doing things! If I understand your first post that the datagrid is populated in the forms_load event.

sorry guys thats not working either i think it must be the way ive got my forms set up and maybe im not using the binding controls to there full use or its probs just me and i need to get my head around it more, im new to sql and havent fully explored it yet ill keep plugging away and hopefully will get this resolved. thanks for all your posted and help though i think ill lay it all out as you both surgested.

[jmcilhinney]

These are the steps you should take:

1. Open main form.
2. Load data into DataTable and bind to DataGridView.
3. Open dialogue.
4. User enters data.
5. Close dialogue.
6. Main form gets data from dialogue.
7. Main form creates new row and adds to DataTable, which inherently updates the bound grid.
8. Main form saves contents of Datatable to database.

[Roofuss]

Thanks ive followed your steps and....... IT WORKS!! thanks for all your help it works a treat now