Display data from differente tables in one 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.

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.

I also need to edit, delete and insert records from the grid.

Any ideas?

Best regards,

--
Gabriel León Valenzuela