01.SqlConnection Conn = new SqlConnection(@"Data Source=.;Initial Catalog=Northwind;Integrated Security=True");
02. private void btnShow_Click(object sender, EventArgs e)
03. {
04. string sql = "Select * from orders Where OrderDate Between @rpStart AND @rpTo";
05. SqlCommand cmd = new SqlCommand(sql, Conn);
06. cmd.Parameters.AddWithValue("@rpStart", Convert.ToDateTime(dtpStart.Value));
07. cmd.Parameters.AddWithValue("@rpTo", Convert.ToDateTime(dtpTo.Value));
08.
09. SqlDataAdapter da = new SqlDataAdapter(cmd);
10. DataTable dt = new DataTable();
11. da.Fill(dt);
12.
13. reportViewer1.LocalReport.DataSources.Clear();
14. ReportDataSource source = new ReportDataSource("DataSet1", dt);
15. reportViewer1.LocalReport.ReportPath = @"..\..\Report1.rdlc";
16. reportViewer1.LocalReport.DataSources.Add(source);
17.
18. ReportParameterCollection rp = new ReportParameterCollection();
19. rp.Add(new ReportParameter("rpStart", dtpStart.Value.ToString("dd-MM-yyyy 00:00:00")));
20. rp.Add(new ReportParameter("rpTo", dtpTo.Value.ToString("dd-MM-yyyy 00:00:00")));
21.
22. reportViewer1.LocalReport.SetParameters(rp);
23. reportViewer1.RefreshReport();
24. }
