string path = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True"; SqlConnection con1 = new SqlConnection(path); con1.Open(); const string query = "select * From [Table1] where date between @from and @to"; SqlCommand com1 = new SqlCommand(query, con1); com1.Parameters.AddWithValue("@from", DateTime.Parse(r1)); com1.Parameters.AddWithValue("@to", DateTime.Parse(r2)); SqlDataAdapter adp1 = new SqlDataAdapter(com1); DataSet ds1 = new DataSet(); adp1.Fill(ds1); com1.ExecuteNonQuery(); con1.Close(); GridView1.DataSource = ds1; GridView1.DataBind(); ReportViewer1.Reset(); ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("Temp", ds1.Tables[0])); ReportViewer1.LocalReport.Refresh();
ReportViewer1.LocalReport.DataSources.Add(New ReportDataSource("Dataset1", ds1.Tables("DataTable1")))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)