@@@@@@@@@@@@@@@@@存储过程。没遇到过的问题??看看
string pd="";
sqlcm=new SqlCommand("pr_frequency",sqlcn);
sqlcm.CommandType=CommandType.StoredProcedure;
SqlParameter nameParam = sqlcm.Parameters.Add("@time", SqlDbType.VarChar,50);
nameParam.Value = time;
SqlParameter nameParam1 = sqlcm.Parameters.Add("@grade",SqlDbType.Int);
nameParam1.Value = Convert.ToInt32(grade);
SqlParameter idParam2 = sqlcm.Parameters.Add("@pd", SqlDbType.Int);
idParam2.Direction = ParameterDirection.Output;
sqlcn.Open();
SqlDataReader sqlr;
sqlr=sqlcm.ExecuteReader();
if(sqlr.Read())
{
pd=sqlr["pd"].ToString();
}
sqlcm.Dispose();
sqlcn.Close();
return pd;
------------------------
当我执行到sqlr=sqlcm.ExecuteReader(); 就说我的添加的参数过多?是什么意思呢