详解C#执行存储过程并将结果填充到GridView的示例代码

SelectSql sq = new SelectSql();

SqlConnection conn = new SqlConnection(sq.lc);

conn.Open();

SqlDataAdapter rd = new SqlDataAdapter();

DataSet ds=new DataSet();

SqlCommand sqlcom = new SqlCommand("dbo.selectjf",conn);

sqlcom.Parameters.Add("@name", SqlDbType.VarChar,20).Value = NameText.Text;

sqlcom.Parameters.Add("@sfzh",SqlDbType.VarChar,30).Value = SfText.Text;

sqlcom.CommandType = CommandType.StoredProcedure;

rd.SelectCommand = sqlcom;

rd.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

conn.Close();

ds.Dispose();

rd.Dispose();