Adding datarow to datatable in c# ..

See more:

C#

ASP.NET

SQL-Server

ADO.NET

SqlDataAdapter da = new SqlDataAdapter("Select * from mytable", SqlConnection);

DataSet ds = new DataSet();
da.Fill(ds);

DataRow row1 = ds.Tables[0].NewRow();

row1["ID"] = 1;
row1["Name"] = "XYZ";

ds.Tables[0].Rows.Add(row1);

da.Update(ds);



Exception occurrs at the line : da.Update(ds);

Update requires a valid InsertCommand when passed DataRow collection with new rows.