Sunday, 15 February 2015

Databinding in ComboBox in C#

In this Article, we will see How to bind data in ComboxBox from database in C# Windows Form Application. In previous post, we saw How to:

Let's Begin:
1. Go to New -> Project -> Select Windows Form Application.
2. Create a Database (named as Sample). Add a Table tbl_Country. The following is the table schema for creating tbl_Country.
3. Drop Label and ComboBox control from the toolbox.
Form1.cs Code:

using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace ComboBoxDataBind
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        //Form Load
        private void Form1_Load(object sender, EventArgs e)
        {
            fillComboBox();
        }
        //fillComboBox method for filling the ComboBox with Data
        private void fillComboBox()
        {
            try
            {
                using (SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Sample;Integrated Security=true;"))
                {
                    con.Open();
                    SqlDataAdapter adapt = new SqlDataAdapter("Select * from tbl_Country", con);
                    DataTable dt = new DataTable();
                    adapt.Fill(dt);
                    //Set Displaymember as Country
                    cmb_Country.DisplayMember = "Country";
                    //Set ValueMember as ID
                    cmb_Country.ValueMember = "ID";
                    cmb_Country.DataSource = dt;
                }
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        //cmb_Country_SelectedIndexChanged Event
        private void cmb_Country_SelectedIndexChanged(object sender, EventArgs e)
        {
            lbl_DisplayValue.Text = cmb_Country.SelectedValue.ToString();
        }
    }
}
In the above code, I have created fillComboBox() method for filling the ComboBox with data and also created cmb_Country_SelectedIndexChanged event which fires when the SelectedIndex property changed.
Final Preview:
Hope you like it. Thanks.
[Download Source code via Google Drive]

3 comments:

  1. I am strugglling with "Data Source=.;Initial Catalog=Sample;Integrated Security=true;"))
    as I do not know how to write it in my application.
    Can you tell me what it is and also what I need to write for my application.

    Regards

    ReplyDelete
    Replies
    1. "Data Source=.;Initial Catalog=Sample;Integrated Security=true;" is a connection string that includes the source database name, and other parameters required to establish the initial connection with database. Please create a Database (named as Sample) and add a Table tbl_Country and follow each step as shown in this Post.

      Delete

Subscribe Now

Popular Posts

Contact us

Name

Email *

Message *

Subscribe us on YouTube

Like us on Facebook

Follow us on Google+