error source is System.DataUpdate for da.update command in vb.net...pls help

[kamalika_kk]

please go through the following code...i'v tried to apply the disconnected mode using dataset and data adapter...it's givng an error of this fashion... "System.DataUpdate requires a valid Insertcommand when passed DataRow collection with new row" for the da.update command in addcmd_click event......please help Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim con As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\Documents and Settings\Administrator\Desktop\exp_mod\exp.mdb;" cn.ConnectionString = con dao = New OleDbDataAdapter("select * from exp_mas_bank", cn) dao.Fill(ds, "bank") End Sub Private Sub addcmd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles addcmd.Click Dim drs As DataRow = ds.Tables("bank").NewRow drs(0) = cdtxt.Text drs(1) = nmtxt.Text drs(2) = addtxt.Text ds.Tables("bank").Rows.Add(drs) Try dao.Update(ds, "bank") Catch ex As Exception MsgBox(ex.Source & ex.Message) End Try End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ds.Tables("bank").Rows(0)("code") = ds.Tables("bank").ToString & " ***" Try cn.Open() dao.Update(ds, "bank") cn.Close() Catch ex As Exception MsgBox(ex.Source & ex.Message) End Try End Sub:(

[Ritesh1234]

Hi kamalika, Before calling dao.Update to insert/update or delete data from Dataset to database you have to set the dao.InsetCommand,dao.UpdateCommand and dao.DeleteCommand property with approriate command Regards, Ritesh