Hey there, im stuck now with the datagridview not being able to discard the old headings in it and load another table in access.

this is how the test program works
i have 2 buttons.

start the program, and press one button - the datatable loads
close the program, and press the other button - the other datatable loads

but now, start the program press the one button - the datatable loads, Now,
without exiting press the second button, and it only adds the headings of the other table?

i have no idea how to "reset" the datagridview.

here is my code

private void button3_Click(object sender, EventArgs e)
        {
            string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb";
            string query = "SELECT * FROM Table1";   <------- the one table

            //create an OleDbDataAdapter to execute the query
            dAdapter = new OleDbDataAdapter(query, connString);

            //create a command builder
            OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter);
            //fill the DataTable
            dAdapter.Fill(dTable);

            //the DataGridView
            DataGridView dgView = new DataGridView();

            //BindingSource to sync DataTable and DataGridView
            BindingSource bSource = new BindingSource();

            //set the BindingSource DataSource
            bSource.DataSource = dTable;

            //set the DataGridView DataSource
            dataGridView1.DataSource = bSource;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb";
            string query = "SELECT * FROM Expenditure"; <--- second table

            //create an OleDbDataAdapter to execute the query
            dAdapter = new OleDbDataAdapter(query, connString);

            //create a command builder
            OleDbCommandBuilder cBuilder = new OleDbCommandBuilder(dAdapter);
            //fill the DataTable
            dAdapter.Fill(dTable);

            //the DataGridView
            DataGridView dgView = new DataGridView();

            //BindingSource to sync DataTable and DataGridView
            BindingSource bSource = new BindingSource();

            //set the BindingSource DataSource
            bSource.DataSource = dTable;

            //set the DataGridView DataSource
            dataGridView1.DataSource = bSource;
        }

Thank you. =)
Ruan

Change lines 15 and 41 to

dataGridView1 = new DataGridView();

Hope this helps

Change lines 15 and 41 to

dataGridView1 = new DataGridView();

Hope this helps

=) Thank you. It worked =)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.