存储过程返回表

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();