Winform动态生成报表

 private void button1_Click(object sender, EventArgs e)

        {

           string sqlstr= ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

           SqlConnection conn = new SqlConnection(sqlstr);

           conn.Open();

           string str = "select * from tbl_ClientInfo where nID='5'";

           SqlDataAdapter sda = new SqlDataAdapter(str,conn);

           DataSet ds = new System.Data.DataSet();

           sda.Fill(ds);

           conn.Close();

           reportViewer1.LocalReport.DataSources.Clear();

           reportViewer1.LocalReport.ReportEmbeddedResource = "ReportRDLC.Report1.rdlc";

            reportViewer1.LocalReport.ReportPath=Application.StartupPath+ @"\Report1.rdlc";

           //MessageBox.Show(Application.StartupPath + @"\Report1.rdlc");

           Microsoft.Reporting.WinForms.ReportDataSource reportDataSource = new ReportDataSource();

           reportDataSource.Name = "DataSet1";       //指定数据源的名字，是你在设计器中指定的

           reportDataSource.Value = ds.Tables[0];//指定数据源，也就是你查出来的dataTable

           reportViewer1.LocalReport.DataSources.Add(reportDataSource);

           

           reportViewer1.RefreshReport();

        }