Selecting table from database with combobox and populating datagridview-can't get it to work

Question

OleDbDataAdapter da2 = new OleDbDataAdapter("SELECT nazivMaterijala FROM popisMaterijala",     con);
DataTable dt = new DataTable();
da2.Fill(dt);
BindingSource bndSource2 = new BindingSource();
bndSource2.DataSource = dt;
this.comboBox1.DataSource = bndSource2;
comboBox1.DisplayMember = "nazivMaterijala";
comboBox1.ValueMember = "nazivMaterijala";

with this part of code i get the table names into combobox

private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
    {
        OleDbConnection con = new OleDbConnection(connectionString);
        OleDbDataAdapter da2 = new OleDbDataAdapter("SELECT * FROM ["     +this.comboBox1.SelectedValue.ToString() +"]", con);
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        da2.MissingSchemaAction = MissingSchemaAction.AddWithKey;
        da2.Fill(dt);
        this.dataGridView1.DataSource = dt; 
    }

after selecting something from combobox1 it should populate the gridview with data from selected table, but can't get it to work

This is the message i get when I try to run it: The Microsoft Access database engine cannot find the input table or query 'System.Data.DataRowView'. Make sure it exists and that its name is spelled correctly.

Try adding this line after setting data source this.dataGridView1.DataBind(); — Swapnil, Jun 24 '13 at 14:20
Nothing, the error I mentioned above I get in this line-> "da2.Fill(dt);" — user2516578, Jun 24 '13 at 14:25
Try placing `this.comboBox1.DataSource = bndSource2;` **after** the definition of `DisplayMember` and `ValueMember` — Andre Calil, Jun 24 '13 at 14:28

Bearcat9425 · Answer 1 · 2013-06-24T14:42:57.520

What I think is happening is that you are binding your combobox to the Datarows of your dataset returned from the first query. So when you do a toString on the selected value you are just outputting System.Data.DataRowView. You need to cast your selected Item to System.Data.DataRowView, then find the correct column in it that contains the TableName and pass that into your second query. Something like this. Also Keep in mind if nothing is selected you need to check to make sure selectedItem is not null.

DataRowView dView = (DataRowView)this.comboBox1.SelectedItem;
OleDbDataAdapter da2 = new OleDbDataAdapter("SELECT * FROM ["     + dView.Row["ColumnName that contains TableName"].ToString() +"]", con);

score 0 · Accepted Answer · edited May 23 '17 at 11:56

Try to use the SelectionChangeCommitted instead. The SelectedValueChanged event is raised during binding and in this context the actual values DisplayMember and ValueMember are not properly set

private void comboBox1_SelectionChangeCommitted(object sender, EventArgs e)
{
    // Better to be safe here.....
    if (this.comboBox1.SelectedValue == null)
        return;

    using(OleDbConnection con = new OleDbConnection(connectionString))
    using(OleDbDataAdapter da2 = new OleDbDataAdapter("SELECT * FROM ["     +this.comboBox1.SelectedValue.ToString() +"]", con))
    {
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        da2.MissingSchemaAction = MissingSchemaAction.AddWithKey;
        da2.Fill(dt);
        this.dataGridView1.DataSource = dt; 
    }
}

See also this question for a better explanation of the problem

Selecting table from database with combobox and populating datagridview-can't get it to work

2 Answers2