What is the problem in above code ?Code:Me.SqlDataAdapter1.SelectCommand.CommandText = "select * from customer" MsgBox(Me.DataSet11.Tables(0).Rows.Count) Dim d As DataRow = DataSet11.Tables(0).NewRow d.Item("cname") = "abc" d.Item("address") = "abc" DataSet11.Tables(0).Rows.Add(d) Me.DataSet11.AcceptChanges() Me.SqlDataAdapter1.Update(DataSet11) MsgBox(Me.DataSet11.Tables(0).Rows.Count)
Thia code doesnot give me any error.
BUt does not add row in my sql database.
Here id is autonumber field.
Please tell me.