how to more than table append in one dataset

Jayakumars
Posted by Jayakumars under ASP.NET AJAX category on | Points: 40 | Views : 1225
Hi
I have post the sample how to more than table append in one dataset

C# Code

sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("Sp_CollectDt", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.CommandText = "Sp_CollectDt";
sqladp.SelectCommand = sqlcmd;
sqladp.Fill(ds);


Sql server Stored Procedure

Create PRoc Sp_CollectDt
as
Select GETDATE()
select GETUTCDATE()
Select * from sys.tables

Comments or Responses

Login to post response