小弟初学C#,有点地方不懂
哪位朋友有多层外取获得参数的方法。用的是NORTHWND数据库,在第二层钻取时,获取不到参数值,报错,就是这句orderReport = lp.GetParameters()["OrderID"].Values[0].Trim();。
哪位高手帮我看看。谢谢!
以下是钻取事件的代码,分不多,不好意思 了大家!
LocalReport lp = (LocalReport)e.Report;
string orderReport = null;
SqlCommand cmd = new SqlCommand(); string paraName = null;
using (SqlConnection conn = new SqlConnection(constr))
{
try
{
orderReport = lp.GetParameters()["customerID"].Values[0].Trim();
cmd.CommandText = string.Format(@"select * from orders where CustomerID='{0}'", orderReport);
cmd.Connection = conn;
}
catch (Exception E)
{ orderReport = lp.GetParameters()["OrderID"].Values[0].Trim();
var hhhh = lp.GetParameters().First().Values[0].ToString();
cmd.CommandText = string.Format(@"select * from [Order Details] where OrderID='{0}'", orderReport);
cmd.Connection = conn; }
finally
{}
哪位朋友有多层外取获得参数的方法。用的是NORTHWND数据库,在第二层钻取时,获取不到参数值,报错,就是这句orderReport = lp.GetParameters()["OrderID"].Values[0].Trim();。
哪位高手帮我看看。谢谢!
以下是钻取事件的代码,分不多,不好意思 了大家!
LocalReport lp = (LocalReport)e.Report;
string orderReport = null;
SqlCommand cmd = new SqlCommand(); string paraName = null;
using (SqlConnection conn = new SqlConnection(constr))
{
try
{
orderReport = lp.GetParameters()["customerID"].Values[0].Trim();
cmd.CommandText = string.Format(@"select * from orders where CustomerID='{0}'", orderReport);
cmd.Connection = conn;
}
catch (Exception E)
{ orderReport = lp.GetParameters()["OrderID"].Values[0].Trim();
var hhhh = lp.GetParameters().First().Values[0].ToString();
cmd.CommandText = string.Format(@"select * from [Order Details] where OrderID='{0}'", orderReport);
cmd.Connection = conn; }
finally
{}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货