c# windows水晶报表，如何在水晶报表中显示数据表

本文关键字：报表 水晶 显示 数据表 windows | 更新日期: 2023-09-27 18:08:53

这是我的代码，我在运行代码时得到一个错误。

private void Form2_Load(object sender, EventArgs e)
{
    string sql = "SELECT * FROM Worker ";
    SqlConnection connection = new SqlConnection(connectonString);
    SqlDataAdapter da = new SqlDataAdapter(sql, connection);
    DataTable dt = new DataTable();
    da.Fill(dt);
    CrystalReport1 cr = new CrystalReport1();
    cr.SetDataSource(dt);
    crystalReportViewer1.ReportSource = cr;
    crystalReportViewer1.Refresh();
}

c# windows水晶报表，如何在水晶报表中显示数据表

重复问题:如何将Crystal Report绑定到手动创建的数据集

你需要这样做:

            Invoice invoice = new Invoice(); // instance of my rpt file
            var ds = new DsBilling();  // DsBilling is mine XSD
            var table2 = ds.Vendor;
            var adapter2 = new VendorTableAdapter();
            adapter2.Fill(table2);

            var table = ds.Bill;
            var adapter = new BillTableAdapter();
            string name = cboCustReport.Text;
            int month = int.Parse(cboRptFromMonth.SelectedItem.ToString());
            int year = int.Parse(cboReportFromYear.SelectedItem.ToString());
            adapter.Fill(table, name,month,year);
            ds.AcceptChanges();
            invoice.SetDataSource(ds);
            crystalReportViewer1.ReportSource = invoice;
            crystalReportViewer1.RefreshReport();
相关文章：