private void checkBox1_CheckedChanged(object sender, EventArgs e) { AdvancerworldDataSetxsdTableAdapters.paymentsTableAdapter adapter = new AdvancerworldDataSetxsdTableAdapters.paymentsTableAdapter(); AdvancerworldDataSetxsd.paymentsDataTable table = new AdvancerworldDataSetxsd.paymentsDataTable(); adapter.Fill(table); ReportDataSource MyNewDatSource = new ReportDataSource("Staffname", (DataTable)table); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(MyNewDatSource); this.reportViewer1.LocalReport.Refresh(); this.reportViewer1.RefreshReport(); }
private void button1_Click(object sender, EventArgs e) { AdvancerworldDataSetxsdTableAdapters.paymentsTableAdapter adapter = new AdvancerworldDataSetxsdTableAdapters.paymentsTableAdapter(); AdvancerworldDataSetxsd.paymentsDataTable table = new AdvancerworldDataSetxsd.paymentsDataTable(); adapter.FillByVen(table, vendername.Text); ReportDataSource MyNewDatSource = new ReportDataSource("Staffname", (DataTable)table); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(MyNewDatSource); this.reportViewer1.LocalReport.Refresh(); this.reportViewer1.RefreshReport(); }