- string conStr = "Data Source=.;Initial Catalog=Book;Integrated Security=True";
- SqlConnection con = new SqlConnection(conStr);
- con.Open();
- SqlDataAdapter da = new SqlDataAdapter("SELECT top 10 * from [dbo].[CuserInfo]", con);
- BookDataSet ds = new BookDataSet(); /*添加的一个DataSet*/
- /*通过SqlDataAdapter适配器为DataTable填充(或添加)数据*/
- da.Fill(ds.Tables["CuserInfo"]);
- this.CuserInfoBindingSource.DataSource = ds.Tables["CuserInfo"];
- this.reportViewer1.LocalReport.ReportEmbeddedResource = "MyRDLC.MyReport.rdlc";
- /*方法一:要引用using Microsoft.Reporting.WinForms;命名空间
- *
- * ReportDataSource rds = new ReportDataSource("BookDataSet_CuserInfo", ds.Tables["CuserInfo"]);
- * this.reportViewer1.LocalReport.DataSources.Add(rds);
- *
- */
- this.reportViewer1.LocalReport.DataSources.Clear();
- /*方法二*/
- this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("BookDataSet_CuserInfo", ds.Tables["CuserInfo"]));
- this.reportViewer1.RefreshReport();
其中:BookDataSet_CuserInfo 表示/*数据集名_表名*/ ds.Tables["CuserInfo"] 表示 /*数据源(表)*/不能为DataSet