ComboBox - DataGridView Sample


The Article Demonstrate the how to change the DataSource Property of DataGridView Dynamically.

Requirements:

  • ComboBox Control
  • DataGridView Control

Description:

  • The method is so easy to handle.
  • Here, I am taken an XML file as DataBase file.
  • The Article shows displaying data into DataGridView Control of table name selected from the ComboBox Control.

Arrangements:

  1. Create a new instance of the System.Data.DataSet class.

    DataSet Dset = new DataSet();

    Listing 1
     
  2. Now, on the Form_Load event handler read an XML file using DataSet Object.

    Dset.ReadXml("..\\..\\XMLData.xml");

    Listing 2
     
  3. Then add all the TableName avail in the DataSet Object to the ComboBox items collection. Result is displayed in Figure 1.

    for (int item=0; item < Dset.Tables.Count;item++ )
    {
              comboBox1.Items.Add(Dset.Tables[item].
              TableName.ToString());
    }

    Listing 3

    ComboBox1.gif

    Figure 1
     

  4. After this, set the DataSource property of DataGridView to the selected item of ComboBox.

    private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
    {
             dataGridView1.DataSource = null;
             dataGridView1.DataSource = Dset.Tables[comboBox1.Text];
    }


    Listing 4

Output: Following snapshots shows the intended result.

ComboBox - DataGridView Sample

Figure 2

ComboBox - DataGridView Sample

Figure 3

Summary:

In this session, we have seen the ComboBox - DataGridView operation for displaying table data dynamically from the selected item of ComboBox Control.