Updating with a dataset

[flann]

I'm trying to update an sql database using a datagrid and asp.net.

sqlconnection1.open
sqldataadpter1.update(dataset1, "ClientInfo")
sqldataadapter.executenonquery()
sqlconnection1.close

Can anybody lend a hand?

 

[nakracreative]

If you provide the type of error generated then it would be of great help in understanding your problem. you cannot write both executenonquery and update methods simulatneoulsy. if you are updating a database using the update method of dataadapter class then you must not be using the executenonquery as it is reuqired in case when you have the parameters collection.