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()
        //Form Load
        private void Form1_Load(object sender, EventArgs e)
        //fillComboBox method for filling the ComboBox with Data
        private void fillComboBox()
                using (SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Sample;Integrated Security=true;"))
                    SqlDataAdapter adapt = new SqlDataAdapter("Select * from tbl_Country", con);
                    DataTable dt = new DataTable();
                    //Set Displaymember as Country
                    cmb_Country.DisplayMember = "Country";
                    //Set ValueMember as ID
                    cmb_Country.ValueMember = "ID";
                    cmb_Country.DataSource = dt;
            catch(Exception ex)
        //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]


  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.


    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.


Subscribe Now

Popular Posts

Contact us


Email *

Message *

Subscribe us on YouTube

Like us on Facebook

Follow us on Google+