Multiple DataTables in Dataset

[Guest]

Hi,

I am returning multiple datatables from a stored procedure into a dataset.
It keeps naming the datatables as "Table","Table1","Table2" etc. Is there a
way i can change the sproc so that my datatables get created with a name ?
The multiple select statements have multiple joins too so i am not sure where
to alias it. I do not want to depend on the indexes to grab the right tables.
Let me know if there's a solution.

Thanks!

 

[Cor Ligthert]

Vish,

da1.Fill(ds, "mytablename1") /;with C#


I hope this helps,

Cor

 

[W.G. Ryan eMVP]

In addition to what Cor mentioned, you can specify TableMappings which can
handle this for you
http://msdn.microsoft.com/library/d...acommondataadapterclasstablemappingstopic.asp

 

[Sahil Malik [MVP]]

You will have to do this within ADO.NET. There are three options.

a) Set the TableName property.
b) use tablemappings.
c) Use an overload of fill.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[WJ]

It keeps naming the datatables as "Table","Table1","Table2" etc. Is there
a
way i can change the sproc

You do not need to to change your sProc, leave it the way it is. Just map
the default DataAdapter table names ("Table","Table1","Table2") to the order
that your sProc is retrieving data now.

Example: If your sProc reads three tables from Northwind DB as Employees,
Customers, and Orders tables (in that order), then in your code behind, do
the mappings as shown below:

1. yourSqlDataAdapter.TableMappings.Add("Table","Employees");
2. yourSqlDataAdapter.TableMappings.Add("Table1","Customers");
3. yourSqlDataAdapter.TableMappings.Add("Table2","Customers");
4. Call the fill method as: yourSqlDataAdapter.Fill(yourDataset);

John

 

[WJ]

3. yourSqlDataAdapter.TableMappings.Add("Table2","Customers");

Correction: It should read "Orders", not "Customers" for the last table

John

 

[Guest]

I knew how to do this but the question is whether it can be done in the sproc
? This code depends on the ado.net knowing what sequence is going to come
back for the datatables and if it already knows then i am fine using the
original names as it is. What i want is without assuming the indexes return a
name from the sproc.
Thanks!

 

[Marc Scheuner [MVP ADSI]]

I knew how to do this but the question is whether it can be done in the sproc

?

No. This naming behaviour is a thing of your ADO.NET client code - no
way for the sproc to specify that.

Marc
================================================================
Marc Scheuner May The Source Be With You!
Berne, Switzerland m.scheuner -at- inova.ch

 

[Sahil Malik [MVP]]

You can't name datatables in stored procs.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/