DataSet StoreProcedure Table names

Question

Hi,

I am calling a stored procedure to return two tables. I am getting it as a dataset in my console application. The table names in the dataset are something like TABLE,TABLE1.

Is there anyway to change this to a meaningful names from stored procedure??

Thanks, Mahesh

Answer 1

I don't think you can name DataTables from stored procedures.

Of course it's easy to do this in code. In C# you can do the following, assuming a DataSet dataSet with two DataTables, one named TABLE and the other named TABLE1:

 dataSet.Tables["TABLE"].TableName = "MyBetterTableName";
 dataSet.Tables["TABLE1"].TableName = "AnotherTableName";

and while you're at it, you can name your DataSet:

 dataSet.DataSetName = "MyDataSet";