I am struggling to figure out how to create an event handler for RowUpdating. I am using Visual Web Developer Express 2005 .NET 2.0.
I can't use the wizard because my GridView displays a custom query that joins several database tables. From what I am finding online I need to build a sub routine and then point the RowUpdating Event in the properties pane of my GridView to that sub routine. How do I do this? This is what I am thinking.
Sub update(ByVal sender AsObject, ByVal e As GridViewUpdatedEventHandler)
'How do I know what row in the GridView I have selected?
'I need to update my database table based on a column value that is in the
'row I have selected.
Dim query AsString = "UPDATE table SET values columnName1 = '1' WHERE columnName2 = '" & value from GridView
Dim objcommand10 AsNew Data.SqlClient.SqlCommand(query, New Data.SqlClient.SqlConnection(cnxn))
Side note - What is the difference between RowUpdating and RowUpdated?