I have 2 rows in a datatable
When i Adapter.Update(mytable)
i get Update requires valid update command error
When In Fact I am Inserting
SqlAdapter ad = new SqlDataAdapter()
ad.InsertCommand=new SqlCommand();
string sInsert="Insert into mytable (field1,field2) values(@field1,@field2)
..
..ad.InsertCommand.Parameters.Add("@Field1", SqlDbType.Int, 0, "Field1");
ad.InsertCommand.Parameters.Add("@FileId2", SqlDbType.Int, 0, "Field2");
ad.InsertCommand.Connection=oConn;
ad.Update(MyTable) // crashes with requires valid update command
// if i do this
for (int rows = 0;rows<mytalble.Rows.Count;Rows++)
{
ad.InsertCommand.Parameters["@Field1"].Value=MyTable.Rows[x]["Field1"])
ad.InsertCommand.Parameters["@Field2"].Value=MyTable.Rows[x]["Field2"])
ad.InsertCommand.ExecuteNonQuery() // Works just Fine inserts 2
Rows
}
any idea why the update requires a Update command
Thanks Dave