Help with data displayed in a gridview

[Gabriel León]

Hi,

Im developing a web site. i have a couple of tables in my sql server 2000
and i want them to be displayed by the same gridview by changing the
objectdatasource or tableadapter or whatever.

Ive already created my data connection, Ive included two tableadapters one
for each of my db tables. After these i configure my gridview data source
and i selected an objectdatasource and i assigned it one of the
tableadapters to the business object.

It works perfect at this point. Now im adding a dropdownlist and i would
like to change the data that is displayed in my gridview from one table to
the other when i select a value in this dropdownlist.

I dont know how to change it with code.

Any ideas?

Best regards,

Gabriel León