Can't Update database

Posted 10 August 2008 - 08:55 PM

i face problem in updating database which i only can save my data.....

i use MS SQL 2005 & visual studio 2005....actually i take over this project from previous programmer...she can update the database only using this 2 lines of code.

Me.BindingContext(dsVendor, "MVendor").EndCurrentEdit()
daVendor.Update(dsVendor, "MVendor")

this is the error:
Additional information: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

i try use the same idea to update but i fail.....is that any stored procedure in SQL to be write for update?

thx

This post has been edited by kueh82: 10 August 2008 - 09:05 PM