Change commandtext of dataadapter

[marksilka]

I have an sql data adapter with the commandtext "SELECT * FROM TABLEA".

I have 2 other tables "B" and "C" with the exact same structure as "TABLEA". Can I change the commandtext of the data adapater to "SELECT * FROM TABLEB" and fill it with the rows of that table?

I have a dataset with TABLEA in it. I do a fill like so

daTable.Fill(dsTables.TableA)

 

[sqlsamurai]

I dont see why you couldnt. Try it! Let me know what happens.