--存储过程
create proc select_demo
as
select * from aa
go
//调用方法
SqlCommand cmd = new SqlCommand("select_demo", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "info");
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind();