public double[] pdlquan(string pd_name,double pd_quan)
{
MyOpen();
SqlCommand myCommand = new SqlCommand("pdlquan", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter parameterFatherId3 = new SqlParameter("@pd_name",SqlDbType.VarChar,50);
parameterFatherId3.Value = pd_name.Trim();
myCommand.Parameters.Add(parameterFatherId3);
SqlParameter parameterFatherId4 = new SqlParameter("@pd_quan",SqlDbType.Float,8);
parameterFatherId4.Value = pd_quan;
myCommand.Parameters.Add(parameterFatherId4); SqlParameter parameterItemID = new SqlParameter("@pd_lquan", SqlDbType.Float, 8);
parameterItemID.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(parameterItemID);
SqlParameter parameterItemID1 = new SqlParameter("@pd_qquan", SqlDbType.Int,4);
parameterItemID1.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(parameterItemID1); myCommand.ExecuteNonQuery();
float [] rp=new float[2];
rp[0]=parameterItemID.Value;
rp[1]=parameterItemID1.Value;
return rp;
}我想取得此存储过程函数的两个返回值,一个是int,一个是float,这样写总报错?现在存在一个数组里怎么用?
{
MyOpen();
SqlCommand myCommand = new SqlCommand("pdlquan", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter parameterFatherId3 = new SqlParameter("@pd_name",SqlDbType.VarChar,50);
parameterFatherId3.Value = pd_name.Trim();
myCommand.Parameters.Add(parameterFatherId3);
SqlParameter parameterFatherId4 = new SqlParameter("@pd_quan",SqlDbType.Float,8);
parameterFatherId4.Value = pd_quan;
myCommand.Parameters.Add(parameterFatherId4); SqlParameter parameterItemID = new SqlParameter("@pd_lquan", SqlDbType.Float, 8);
parameterItemID.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(parameterItemID);
SqlParameter parameterItemID1 = new SqlParameter("@pd_qquan", SqlDbType.Int,4);
parameterItemID1.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(parameterItemID1); myCommand.ExecuteNonQuery();
float [] rp=new float[2];
rp[0]=parameterItemID.Value;
rp[1]=parameterItemID1.Value;
return rp;
}我想取得此存储过程函数的两个返回值,一个是int,一个是float,这样写总报错?现在存在一个数组里怎么用?
rp[3]=parameterItemID1.Value;
pdlquan[2]
pdlquan[3]
不知道对不对哈