Hi hoping someone can point me in the right direction.

I am using a datagrid on my webpage which contains a checkbox in col1, a list of subjects in col2 (which have been pulled from a database table) and a dropdownlist in col3. This displays as expected. What I do want is for someone to choose subjects by checking the appropriate checkbox in col1 then using the dropdown for more info in col3. I then need to save which rows were chosen in another table based on userid.

The difficulty i am having is that on the second visit to the page i want the same list of subjects populating the datagrid rows to be visible but i want the subjects that the user previously chose to have the checkbox checked adn the dropdown showing the correct value.

Therefore is it possible to bind the datagrid to one sql table and then use values from another sql table to check off rows or am i going about this in the wrong way.