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.
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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!