Load dataset with two Selects?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've seen examples of creating multiple DataTables in a dataset with using
two separate Fill() commands with separate SELECTs statements.

However, if you have a stored procedure that returns these two SELECTs in
one call, can you load these results into the dataset as two differnet
DataTables but with one Fill() command?

Dave
 
Thanks, but how to do name the datatables differently with one Fill command?
Do you have any sample links?

Miha Markic said:
Hi Dave,

Yes, you can.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Dave said:
Hi,

I've seen examples of creating multiple DataTables in a dataset with using
two separate Fill() commands with separate SELECTs statements.

However, if you have a stored procedure that returns these two SELECTs in
one call, can you load these results into the dataset as two differnet
DataTables but with one Fill() command?

Dave
Click to expand...
Click to expand...
 
Dave said:
Thanks, but how to do name the datatables differently with one Fill command?
Do you have any sample links?
Click to expand...

You need to set up the TableMappings collection for the data adapter.
The DataAdapter will generate names by appending numbers to the first
table name (Table, Table1, Table2, etc.) You can then create data
mappings to rename them:

da.TableMappings.Add("FirstTable1", "SecondTable");
da.TableMappings.Add("FirstTable2", "ThirdTable");
da.Fill(ds, "FirstTable");

--Mike
 
Yes you can - welcome to batched queries, you don't even need a stored proc
to acheive this result.

By Default the tables will be added as Table and Table1, you would have to
use the TableMappings collection to map the tables to their appropriate
names.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
Please reply to the newsgroups instead of email so everyone can benefit from
your reply.


Dave said:
Thanks, but how to do name the datatables differently with one Fill command?
Do you have any sample links?

Miha Markic said:
Hi Dave,

Yes, you can.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Dave said:
Hi,

I've seen examples of creating multiple DataTables in a dataset with using
two separate Fill() commands with separate SELECTs statements.

However, if you have a stored procedure that returns these two SELECTs in
one call, can you load these results into the dataset as two differnet
DataTables but with one Fill() command?

Dave
Click to expand...
Click to expand...
Click to expand...
 
Just to be clear, by default the tables will not be called FirstTable1, and
FirstTable2 .. they will actually be Table,Table1,Table2 .. so the mappings
as shown below will have to be slightly altered, though if you read through
the answer given by Mike, he has specified that in the paragraph.
 
Sahil said:
Just to be clear, by default the tables will not be called FirstTable1, and
FirstTable2 .. they will actually be Table,Table1,Table2 .. so the mappings
as shown below will have to be slightly altered, though if you read through
the answer given by Mike, he has specified that in the paragraph.
Click to expand...

If you pass a table name to DataAdapter.Fill() then the names will be
built using the table you specify:


da.Fill(ds) ==> Table, Table1, Table2, Table3;
da.Fill(ds, "Foo") => Foo, Foo1, Foo2, Foo3

--Mike
 
Back
Top