Sqladapter Insert

[DaveL]

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.InsertComman d=new SqlCommand();
string sInsert="Insert into mytable (field1,field2) values(@field1, @field2)
..
..ad.InsertComm and.Parameters. Add("@Field1", SqlDbType.Int, 0, "Field1");

ad.InsertComman d.Parameters.Ad d("@FileId2", SqlDbType.Int, 0, "Field2");

ad.InsertComman d.Connection=oC onn;

ad.Update(MyTab le) // crashes with requires valid update command

// if i do this

for (int rows = 0;rows<mytalble .Rows.Count;Row s++)

{

ad.InsertComman d.Parameters["@Field1"].Value=MyTable. Rows[x]["Field1"])

ad.InsertComman d.Parameters["@Field2"].Value=MyTable. Rows[x]["Field2"])

ad.InsertComman d.ExecuteNonQue ry() // Works just Fine inserts 2
Rows

}

any idea why the update requires a Update command

Thanks Dave

[Peter Bromberg [C# MVP]]

I don't see in your sample where you are assigning the "sInsert" string to
the CommandText property of the InsertCommand. You also need to set the
CommandType to CommandType.Tex t.
Peter
"DaveL" <dv*****@sbcglo bal.netwrote in message
news:8H******** *******@flpi148 .ffdc.sbc.com.. .

>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.InsertComman d=new SqlCommand();
string sInsert="Insert into mytable (field1,field2)
values(@field1, @field2)
.
.ad.InsertComma nd.Parameters.A dd("@Field1", SqlDbType.Int, 0, "Field1");

ad.InsertComman d.Parameters.Ad d("@FileId2", SqlDbType.Int, 0, "Field2");

ad.InsertComman d.Connection=oC onn;

ad.Update(MyTab le) // crashes with requires valid update command

// if i do this

for (int rows = 0;rows<mytalble .Rows.Count;Row s++)

{
ad.InsertComman d.Parameters["@Field1"].Value=MyTable. Rows[x]["Field1"])
ad.InsertComman d.Parameters["@Field2"].Value=MyTable. Rows[x]["Field2"])

ad.InsertComman d.ExecuteNonQue ry() // Works just Fine inserts 2
Rows

}

any idea why the update requires a Update command

Thanks Dave