为RDLC报表动态绑定数据
?
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