I am trying to write a system which allows users to enter thier details in a form which is then submitted to the database which i have managed to do so far but now i want to be able to let the update the details that they have previously entered in the same form. I have a dataadapter which fills a dataset with thier previously entered details which i then use the following example statements to fill my textboxes with thier previously entered details

TextQ2.Text = DsEntry1.Tables(0).Rows(0).Item("q2_text")

 this works fine so far i want to be able to let then update thier details then submit them directly back to the database but no matter what i try i dont seem to be able to do this

This is my update statement within the sqldataadapter

UPDATE blueprint SET q1 = @q1, q2_text = @q2_text, q3 = @q3, q3_text = @q3_text, q4 = @q4, q4_text = @q4_text, q5 = @q5, q5_text = @q5_text WHERE empno = @empno

 any advice would be greatly appreciated as i have not created an update with a sqldataadapter before

Thanks

Hi,

You can use the CommandBuilder object to automatically generate the DeleteCommand, the InsertCommand, and the UpdateCommand properties of the DataAdapter.

You also can manually create UpdateCommand for DataAdapter.

For more information, see http://support.microsoft.com/kb/308055

 

I look forward to receiving your test results.