Nilsomudra Ответов: 1

Изменение имени таблицы данных в наборе данных

I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset.  The stored procedure is being called from C#/.NET code.
Dataset ds = new Dataset();
ds = return Dataset 

The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,...  when the dataset is received on the .NET side.  Is there a way to define the datatable name within the stored procedure that will be used in the dataset and seen on the .NET side?

1 Ответов

Рейтинг:
1

n.podbielski

Просто используйте как SQL-оператор.

SELECT * FROM Table1 AS AnotherNameForTable.