//增加参数:名称,类型,长度
salesCMD.Parameters.Add
( "@CategoryName ", SqlDbType.NVarChar, 15);
//传入的参数值
salesCMD.Parameters[0].Value = "Beverages ";
salesCMD.Parameters.Add
( "@CategoryName ", SqlDbType.NVarChar, 15);
//传入的参数值
salesCMD.Parameters[0].Value = "Beverages ";
SqlCommand scd_sel=new SqlCommand("up_custompage",sqlConnection1);
scd_sel.CommandType=CommandType.StoredProcedure;
//给存储过程的参数赋值
SqlParameter sp_temp;
sp_temp=scd_sel.Parameters.Add("@vc_order_column_name",SqlDbType.VarChar,50);
sp_temp.Direction=ParameterDirection.Input;
sp_temp.Value=str_order_column;SqlDataAdapter sda=new SqlDataAdapter();
sda.SelectCommand=scd_sel;
if (sqlConnection1.State==ConnectionState.Closed)
{
sqlConnection1.ConnectionString=sqlConStr;
sqlConnection1.Open();
}
DataSet dsSpecialEquipmentInBill=new DataSet();
sda.Fill(dsSpecialEquipmentInBill);
sqlConnection1.Close();
nwindConn.Open();
SqlDataReader myReader = salesCMD.ExecuteReader();
if(myReader.Read())
{
// 取值
}
// 一定记得关闭
nwindConn.Close();