New to Using ASP .net 2.0

Hi all,

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 !

Which one is primary key? table1 or table2?

do All data you populated comes from table1? except for table2.
I didn't understand what you want to do. Because you say 'TABLE1 contains the ID from TABLE1'. Is the dropdownlist in gridview as template column?
Please be clear.

But I think you have to write a query with joins two table?

Apologies for being vague.

I have resolved this now as I didn't realise when configuring the datasource I can actually get the wizard to generate insert and update statements. This seems to have worked.