create procedure test
as
select * from tb
create procedure test
as
begin
declare @t table( ...)
insert into @t...
select * from @t
end
sqlCommand1.CommandType = CommandType.StoredProcedure;
sqlCommand1.CommandText = proceduer_name;
sqlCommand1.Parameters.Add("@tblName",SqlDbType.VarChar,2000);
sqlCommand1.Parameters["@tblName"].Value = tablename;
dapter.SelectCommand = sqlCommand1;
dapter.Fill(dataset);
myDataGrid.DataSource = dataset.Tables[0];
myDataGrid.DataBind();