I have an application that has a datagrid with drop down list control in a template column. I want to set the dropdown list so that it updates the database record when the user makes a change to the value in the drop down list. My problem right now is that I can't access the datagrid field values from the SelectedIndexChanged event of the drop down list. Specifically I need to get the ID of the record from the datagrid row that contains the list box that has had its value changed so that I can do the database update.

Being new to asp.net, how can I allow my drop down box's SelectedIndexChanged event to "see" the other datagrid field values in the datagrid row in which the drop down list resides?

I can post code if it's necessary.

Thanks