NET水晶报表如何动态设置数据源(请教高手,急!100分献上!)
在Visual C# 应用程序里,只建立了一个空白的水晶报表,
我想动态显示SQL Server 数据库的表内容,但总不能如愿,
代码如下:
private SqlConnection sqlCn = null;
private SqlDataAdapter sqlDeDA = null;
private string m_strCn = "Data Source=(local);Initial Catalog=LineMonitor;"
+ "Integrated Security=SSPI;";
private string strSql = "Select * from Device";
sqlCn = new SqlConnection(m_strCn);
sqlDeDA = new SqlDataAdapter(strSql, sqlCn);
DataSet daDataSet = new DataSet();
sqlDeDA.Fill(daDataSet, "Device");
DataTable dt = daDataSet.Tables["Device"];
CrystalReport1 oRpt = new CrystalReport1();
oRpt.SetDataSource(dt);
crystalReportViewer1.ReportSource = oRpt;
Device是数据库LineMonitor的一张表,CrystalReport1是一张空白报表.
crystalReportViewer1是放在窗体上报表显示控件,运行是总是空白的报表,没有任何内容,
急切希望高手指点!!