private void Form1_Load(object sender, EventArgs e)
{
string strSQL = "select * from users";
SqlConnection conn = SystemGlobalVar.DatabaseMethods.getConnection();
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
da.Fill(ds);
CrystalReport1 cr = new CrystalReport1();
cr.SetDataSource(ds);//这里报错该报表不包含表。怎么解决?用ds.Tables[0]也是一样
}
报表跟你SQL语句表是否一致???
报表跟你SQL语句表是否一致???
然后拖一个CrystalReportViewer1控件!
代码:
string strSQL = "select * from users";
SqlConnection conn = SystemGlobalVar.DatabaseMethods.getConnection();
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
da.Fill(ds);ReportDocument doc = new ReportDocument();
doc.Load(Server.MapPath("CrystalReport1.rpt"));
doc.SetDataSource(ds.Tables[0]);
CrystalReportViewer1.ReportSource = doc;
不一定连接特定的数据库!