burner1991
11-24-2003, 02:11 PM
how do you query multiple tables using a dataadapter and then how do you retrieve the data from the data set?
DNAunion2000
11-24-2003, 09:22 PM
burner1991: how do you query multiple tables using a dataadapter and then how do you retrieve the data from the data set?
/*DNAunion*/ If the multi-table query can be "canned" some way, you could create a (parameterized) stored procedure in the underlying RDBMS. The RDBMS would then run the join query on whatever tables are involved and then return to .NET just a single table (dataset).
vBulletin® v3.7.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.