That's the "unique key value" I'm talking about.
NET developer and trying to use a Grid View control to show all the employees in the employee table in the database.
I'm trying to edit an entry and then click "update" to update the entry on my website but then this error shows up. I have the following configured datasourced datatable on my web application: The Sql Data Source object has no way of knowing the precise way to update the table(s) of your application unless you specify an section within the properties of the Sql Data Source.
A very rough example of an Update COmmand property on your data source might be This is GOOD.
I want to conditionally call update statement on sqldatasource. Handle Update(Grid View Row row, Int32 row Index, Boolean causes Validation) 1218 System. Handle Event(Event Args e, Boolean causes Validation, String validation Group) 832 System. Find Control("Drop Down List Job") as Drop Down List; Text Box Notes = row.Description: An unhandled exception occurred during the execution of the current web request. Execute Update(IDictionary keys, IDictionary values, IDictionary old Values) 741 System. Hi all, I have a gridview that bound to a Sql Data Source called Sql Data Source Grid View. Find Control("Drop Down List Pay Type") as Drop Down List; Drop Down List Dept = row.I have enabled Edit in my Grid View, but I do all the updating in code behind with stored procedure (using on Row Updating). Find Control("Drop Down List Dept") as Drop Down List; Text Box Start Time = row. On Bubble Event(Object source, Event Args e) 87 System. Raise Bubble Event(Object source, Event Args args) 35 System. The only part I'm stuck on now is when I have the following query: Update Command="Update Sales SET [email protected], [email protected], [Sale Price][email protected]_Price, [email protected], [Commission Rate][email protected]_Rate, [Commission Earned][email protected]_Earned"There should be a unique key value in the record being updated that you can then provide back to the Update Command as a parameter.Add the "Where" clause to the end of the Update Command in a manner similar to the example I posted, and that should restrict the update to just the record you need.