Error "Update requires a valid InsertCommand"

Question

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?

zsafadi · Answer

use a CommandBuilder to make do all the work in one statment

send2manivannan · Answer

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