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