.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Post New Resource Bookmark and Share   

ComboBox - DataGridView Sample

Posted By:Creative13       Posted Date: September 18, 2012    Points: 200    Category:    URL: http://www.dotnetspark.com  

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.
 


     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend