private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            DataSet1TableAdapters.collectionsTableAdapter adapter = new DataSet1TableAdapters.collectionsTableAdapter();
            //collectionsTableAdapters.collectionsTableAdapter adapter = new collectionsTableAdapters.collectionsTableAdapter();
            //collections.collectionsDataTable table = new komal.collections.collectionsDataTable();
            DataSet1.collectionsDataTable table = new DataSet1.collectionsDataTable();
            adapter.Fill(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();
        }
        private void button2_Click(object sender, EventArgs e)
        {
            DataSet1TableAdapters.collectionsTableAdapter adapter = new DataSet1TableAdapters.collectionsTableAdapter();
            //collectionsTableAdapters.collectionsTableAdapter adapter = new collectionsTableAdapters.collectionsTableAdapter();
            //collections.collectionsDataTable table = new komal.collections.collectionsDataTable();
            DataSet1.collectionsDataTable table = new DataSet1.collectionsDataTable();
            adapter.FillBy(table, vender.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();
        }