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