I don't know what I'm doing wrong.



When I make a change to the datagrid and click the button that has the following code it doesn't update for some reason.

        DataGrid1.Update()
        SqlDataAdapter1.Update(DataSet11)


Please help...

Two possible causes:

1.) Is your sqlConnection open prior to issuing the update commands?
2.) Is there a primary key established for the table being updated?



Best Regards,
Earl Francis

1.) Is your sqlConnection open prior to issuing the update commands?

I'm not sure what you mean by sqlConnection being open. It's connected, I verified that it's connected to the database before I compile the program.

2.) Is there a primary key established for the table being updated?

There are primary keys for each record in the row.



If what I'm saying has nothing to do with what you're asking, please forgive me.. :)

I'm very new to this.

I'm studying out of a book and I followed it to a 'T' on the whole connection wizard steps.

You are most likely using a TableAdapter to connect to your data if you are new and studying from text. Check to make sure that the Update and Delete commands were properly generated. Review your text on configuring TableAdapters if necessary.



Best Regards,
Earl Francis

I redid the sqlconnection, sqldataadaptor and dataset connection. I made sure they were connected. The funny thing is I can update the records in the preview query of the wizard but I can't in the compiled program. I'm pulling my hair out. :)

Please post your code. I think that will help everyone is diagnosing this issue and solving it. ;)

I'm totally brand studying out of a book that seems to be a little misleading sometimes. Anyway, the program just has a datagridview control and 2 command buttons on it with a sqlconnection, sqldataadaptor and dataset connection, connecting to the northwind access database that I imported into sql server. Here's the code. I'm sure I'm missing somethings but please remember I'm new :)


Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click


        SqlDataAdapter1.Fill(DataSet11, "Customers")



        With DataGridView1

            .DataSource = DataSet11

        End With




    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click


        DataGridView1.Update()
        SqlDataAdapter1.Update(DataSet11)

    End Sub
End Class