Getting TableName in Tables of DataSet

Maxim Langman

Hello, I have a little Stored Procedure (SQL Server 2005), which returns some tables. Now, I'm getting those tables in the DataSet in my code. The problem is that I'm not getting TableName of none of the tables. All I get is a default naming convention "Table", Table1", Table2" .... What is the way to get the TableName from SP? How can I basically know which table represents which select in the SP? Thanks, Maxim

PIEBALDconsult

You can't.

Maxim Langman

What do you mean: "you can't"? There has to be some proper way to get tables named then counting them in the SP and then reading them like myDataSet.Tables[5]. And what if SP has been changed? Will I have to recompile the whole project? BTW, If I can't then why do I need this property "TableName" at all?

modified on Tuesday, March 3, 2009 1:55 AM

PIEBALDconsult · modified on Tuesday, March 3, 2009 1:55 AM

Maxim Langman wrote:

There has to be some proper way to get tables named

There isn't. There can't be.

Maxim Langman wrote:

then why do I need this property "TableName" at all

You don't.