data grid update

[KevinMGore]

The following code:
Try
da.Update(ds.Ta bles(dg1Name))
Catch ex As Exception
Console.WriteLi ne(ex.ToString)
MessageBox.Show (ex.ToString)
End Try

causes this error:

System.InvalidO perationExcepti on: Update requires a valid UpdateCommand when
passed DataRow collection with modified rows.
at System.Data.Com mon.DbDataAdapt er.Update(DataR ow[] dataRows,
DataTableMappin g tableMapping)
at System.Data.Com mon.DbDataAdapt er.Update(DataT able dataTable)
at comments.Form1. Button1_Click(O bject sender, EventArgs e) in
G:\Shared\VBSha re\dotnet\Kevin \comments\Form1 .vb:line 161

The code is behiend a button on the form called Update. If I change the data
in the grid I get the error when I press the update button. Any advice will
be much appreciated.

Kevin

[KevinMGore]

Thank you very much - it works now.

"Cor Ligthert" wrote:

Kevin,

I am glad I asked it to show some code, you don't use a commandbuilder, you
only create a placeholder for it. Can you try the changes I wrote in line. I
did it in this message so watch typos.

Public ds As New Data.DataSet()
Public da As SqlClient.SqlDa taAdapter

............

Private Sub Form Load
strConn = "Initial Catalog=data_05 ;Data Source=kevin;Us er
ID=test;passwor d=test;"
strSQL = "select * from sql_oe_comments "
da = New SqlClient.SqlDa taAdapter(strSQ L, strConn)
da.Fill(ds)

dim cmd as new sqlClient.SqlCo mmandBuilder(da )
dg1.DataSource = ds.Tables(0).de faultview

End Sub

Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click

Me.BindingConte xt(dg1.DataSour ce).EndCurrentE dit()

Try

da.update(ds.ta bles(0))

Catch ex As Exception
MessageBox.Show (ex.ToString)
End Try

End Sub

I hope this helps,

Cor