public static DataTable Getshouye(string pagenumber, out int shuchu)
{
DbCommand comm = DataAccess.Createcommand();
comm.CommandText = "getshouye";
DbParameter para = comm.CreateParameter();
para.ParameterName = "@shangpingmiaoshulanght";
para.Value = ShopConfigFile.pageshuliang;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); para = comm.CreateParameter();
para.ParameterName = "@pageshu";
para.Value = pagenumber;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); para = comm.CreateParameter();
para.ParameterName = "@pageshangpinshu";
para.Value = ShopConfigFile.shangpinlanght;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); para = comm.CreateParameter();
para.ParameterName = "@shuchu";
para.Direction = ParameterDirection.Output;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); DataTable table = DataAccess.Executeselectcommand(comm); int mm =Int32 .Parse(comm.Parameters["@shuchu"].Value.ToString()); mm =(int)Math.Ceiling((double)mm / (double)ShopConfigFile.pageshuliang);
return table;
}生成的时候提示
错误 1 控制离开当前方法之前必须对 out 参数“shuchu”赋值
{
DbCommand comm = DataAccess.Createcommand();
comm.CommandText = "getshouye";
DbParameter para = comm.CreateParameter();
para.ParameterName = "@shangpingmiaoshulanght";
para.Value = ShopConfigFile.pageshuliang;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); para = comm.CreateParameter();
para.ParameterName = "@pageshu";
para.Value = pagenumber;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); para = comm.CreateParameter();
para.ParameterName = "@pageshangpinshu";
para.Value = ShopConfigFile.shangpinlanght;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); para = comm.CreateParameter();
para.ParameterName = "@shuchu";
para.Direction = ParameterDirection.Output;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); DataTable table = DataAccess.Executeselectcommand(comm); int mm =Int32 .Parse(comm.Parameters["@shuchu"].Value.ToString()); mm =(int)Math.Ceiling((double)mm / (double)ShopConfigFile.pageshuliang);
return table;
}生成的时候提示
错误 1 控制离开当前方法之前必须对 out 参数“shuchu”赋值
解决方案 »
- ajax 验证
- |zyciis| 在做工行网上支付的接口的时候提交过去的内容变成乱码 怎么回事 大家有没有做过
- gridview问题
- 在ASP.NET中如何设置一个消息提示框?
- 自定义控件属性没有提示
- 求用ASP.netWEB页面实现套打的实现思路
- 如何
- 菜鸟求asp.net2.0下实现图片跑马灯功能
- ###50分请教做过datagrid模板列的朋友,,在.cs中生成datagrid中TemplateColumn模板列的朋友一个问题,关于生成radio的问题,
- 如何对datagrid的页眉和页脚进行操作?
- 请教:在虚拟主机中如何使用urlwrite?
- 紧急求助!上传控件 <input type="file"> 隐藏前面的文本输入框
{
shuchu=0;//一定要赋值
DbCommand comm = DataAccess.Createcommand();
comm.CommandText = "getshouye";
DbParameter para = comm.CreateParameter();
para.ParameterName = "@shangpingmiaoshulanght";
para.Value = ShopConfigFile.pageshuliang;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); para = comm.CreateParameter();
para.ParameterName = "@pageshu";
para.Value = pagenumber;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); para = comm.CreateParameter();
para.ParameterName = "@pageshangpinshu";
para.Value = ShopConfigFile.shangpinlanght;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); para = comm.CreateParameter();
para.ParameterName = "@shuchu";
para.Direction = ParameterDirection.Output;
para.DbType = DbType.Int32;
comm.Parameters.Add(para); DataTable table = DataAccess.Executeselectcommand(comm); int mm =Int32 .Parse(comm.Parameters["@shuchu"].Value.ToString()); mm =(int)Math.Ceiling((double)mm / (double)ShopConfigFile.pageshuliang);
return table;
}
ref 参数在方法外必须给个初始值,这个要注意一下。