Getting TableName in DataSet/DataTable from SP

[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

[ya3mro]

i think you can view code of the dataset and search for tag name and you find inside it all tables data from database

[sharad48]

CREATE PROCEDURE MyProc AS BEGIN Select 'FirstTableName' AS TableName, Column1, Column2 FROM FirstTable Select 'SecondTableName' AS TableName, Column1, Column2 FROM SecondTable Select 'ThirdTableName' AS TableName, * FROM ThirdTable END In the returning DataSet first column for all DataTables will have the TableName you have specified in the SP. You can identify the specific table using these names and assign an appropriate name to your DataTables.

[Maxim Langman]

Good idea, but unfortunatelly doesn't work. It seems like the name of the table (select) never comes from Stored Procedure to the DataSet.Table. This is very sad, because any time the stored procedure is changed, the code has to be recompiled. So what I did, is an additional SELECT with the names of the tables in the order it goes in the SP. This way I know how many tables I get and the names and the order :-)