Updating table from dropdown list
New to Using ASP .net 2.0
I have a grid view with a dropdown list.
When configuring the datasource for the GridView, I am using the wizard to create an update statement.
Trying to use the query builder how would I be able to do the following:
My dropdownlist is populated using a lookup table (TABLE2)
TABLE2 contains ID and description (description is what is populated in the dropdown).
TABLE1 contains the ID from TABLE1
I want to update and ID in TABLE1 taking the dropdown value.
Sorry if this sounds stupid !