.NET2003 C#传递水晶报表参数
紫黑蓝白 2006-12-21 11:55:55 string strTime = "2006-1-2";
DateTime inputTime = Convert.ToDateTime(strTime);
// 创建数据库连接
string conStr = "server=localhost;uid=sa;pwd=sa;database=GMLC;Trusted_Connection=no";
SqlConnection myConnection = new SqlConnection(conStr);
SqlCommand com = null;
Dataset4 dataSet4 = new Dataset4();
try
{
// 打开数据库连接
myConnection.Open();
// 创建查询语句
com = new SqlCommand("SELECT * FROM LCS_Client信息表", myConnection);
SqlDataAdapter adapter = new SqlDataAdapter(com);
adapter.Fill(dataSet4, "LCS_Client信息表");
}
catch (SqlException oe)
{
Label1.Text = oe.Message;
}
finally
{
// 关闭数据库连接
if (myConnection != null)
{
myConnection.Close();
}
}
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue pdValue = new ParameterDiscreteValue();
paramField.ParameterFieldName = "inputTime";
pdValue.Value = inputTime;
paramField.CurrentValues.Add(pdValue);
paramFields.Add(paramField);
//CrystalReport4 cr4 = new CrystalReport4();用这个也不行
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("CrystalReport4.rpt"));
rd.SetDataSource(dataSet4.Tables["LCS_Client信息表"]);
CrystalReportViewer1.ReportSource = rd;
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.DataBind();
CrystalReportViewer1.Visible;
=======
异常详细信息: CrystalDecisions.CrystalReports.Engine.ParameterFieldCurrentValueException: 丢失参数字段当前值。
=======
不知道怎么解决,看了很多资料都不对,高手帮帮忙