private void button1_Click(object sender, EventArgs e) { MySalesTableAdapters.salesreturnTableAdapter adapter = new MySalesTableAdapters.salesreturnTableAdapter(); MySales.salesreturnDataTable table = new MySales.salesreturnDataTable(); adapter.FillByDateval(table, fromdate.Text, todate.Text); ReportDataSource MyNewDatSource = new ReportDataSource("DataSet1", (DataTable)table); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(MyNewDatSource); this.reportViewer1.LocalReport.Refresh(); this.reportViewer1.RefreshReport(); }
private void checkBox1_CheckedChanged(object sender, EventArgs e) { if (checkBox1.Checked) { MySalesTableAdapters.salesreturnTableAdapter adapter = new MySalesTableAdapters.salesreturnTableAdapter(); MySales.salesreturnDataTable table = new MySales.salesreturnDataTable(); adapter.FillByDate(table); ReportDataSource MyNewDatSource = new ReportDataSource("DataSet1", (DataTable)table); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(MyNewDatSource); this.reportViewer1.LocalReport.Refresh(); this.reportViewer1.RefreshReport(); } }