1
Answer

Hii, How can i set names for the tables that i get from stored procedure?

Photo of elad yefet

elad yefet

18y
2.5k
1

hello you there :)

i run stored procedure from ASP.NET that return me 2 Tables
for example, this is the Stored Procedure Code:
////////////////////////////
CREATE PROCEDURE dbo.sp_Info

AS

SELECT *
FROM   dbo.Employees

SELECT *
FROM  dbo.Orders

GO
///////////////////////////

the problem is when i try to use the myDataSet.Tables["Table"];
 
i want to use the real name of Tables tables and not like Tables["Table"]

is someone have an idea?

thanks alot,

elad

Answers (1)