我的数据哪里去了??????????????????????????
使用水晶报表,动态设置数据源,但是数据不能显示,是什么问题?
代码如下:
private void Form2_Load(object sender, EventArgs e)
{
string sql = "select * from Employees";
string DBConfig_sql = @"Data Source=GRITH2O\SQL2000;Initial Catalog=northwind;User ID=sa;Password=sa";
DataSet ds = new DataSet();
SqlConnection sqlCon = new SqlConnection(DBConfig_sql);
SqlCommand sqlCmd = new SqlCommand(sql, sqlCon);
SqlDataAdapter sqlAd = new SqlDataAdapter();
sqlAd.SelectCommand = sqlCmd;
sqlAd.Fill(ds, "Employees");
this.CrystalReport11.Load(Application.StartupPath + "CrystalReport.rpt");
CrystalReport11.SetDataSource(ds.Tables["sql"]);
//{?}中的参数可以不用赋值,即使赋了值也不起作用。
// CrystalReportSource1.ReportDocument.ParameterFields["Parm"].CurrentValues.AddValue("1234567");
// crystalReport1.ParameterFields["Title"].CurrentValues.AddValue("这时推模式的报表样例!");
this.crystalReportViewer1.ReportSource = CrystalReport11;
}
请各位大侠指点!