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