elad yefet

elad yefet

  • NA
  • 4
  • 0

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

Jun 18 2006 2:07 AM

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)