Error "Update requires a valid InsertCommand"

repkin05

I have dataRow as named dRow; I have dataSet as named dSet; I have dataAdapter as named adapter; I have set like that dRow = dSet.Tables[0].NewRow(); then I have set dRow like dRow["colName"] = "value"; and then I have wrote that dSet.Tables[0] .Rows.Add( dRow ); at last I write that adapter.Update( dSet , "tableName" ); But it gives tihs error "Update requires a valid InsertCommand when passed DataRow collection with new rows." But I have insert only one row. Why it gives this error and how can I fix it?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

zsafadi22y ago
use a CommandBuilder to make do all the work in one statment
send2manivannan22y ago
Hi, Here Update means Commit the Changes to the Database Server. So you need to give the InsertCommand for DataAdapter. DataAdapter have the Following Commands, SelectCommand - To fetch the Data from DB InsertCommand - To insert the Columns to DB UpdateCommand - To Update/Modify the Existing Value to DB DeleteCommand - To Delete the Existing Row. For more please refer the MSDN - SQLDataAdapter or OledbDataAdapter. -ManivannanD