Visual C如何执行存储过程

Question

//声明执行存储过程的SqlCommand 
SqlCommand scd_cx=new SqlCommand("cxok",sqlConnection1);
scd_cx.CommandType=CommandType.StoredProcedure;
//给存储过程的参数赋值             
SqlParameter sp_temp1=scd_cx.Parameters.Add("@st",SqlDbType.NVarChar,6);
SqlParameter sp_temp2=scd_cx.Parameters.Add("@en",SqlDbType.NVarChar,6);
sp_temp1.Value=start.Text;
sp_temp2.Value=end.Text;
//执行存储过程
SqlDataAdapter sda=new SqlDataAdapter();
sda.SelectCommand=scd_cx;
if (sqlConnection1.State==ConnectionState.Closed)
sqlConnection1.Open();
DataSet ds=new DataSet();sda.Fill(ds,"tb1");
sqlConnection1.Close();
//绑定数据源
DataGrid1.DataSource=ds.Tables["tb1"];
DataGrid1.DataBind();

Answer 1

谢谢 fyfok(饿人谷) ，我用另外的方式已经解决了，没用上，可是我还是要感谢你，接分了！