How to Bind Data to ComboBox from Database in Windows Form || How to Set Default Select Item in ComboBox using C#.Net.

To implement this concept you need to follow the below steps :

Step1 :
First you need to design a table in Sql Database to retrieve the records from database.

Step2:
On the File menu, click New Project. Select Windows Forms Application as your project type.
Design the Form using controls from Toolbox.

 

Step3: 

Now open the Form.cs page and write the following source code.

Form.cs Code :

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace combox_binding

{

    public partial class Form1 : Form

    {

        SqlConnection con = new SqlConnection("Data Source=sridhar;Initial Catalog=employee;User ID=sa;Password=123");

        public Form1()

        {

            InitializeComponent();

            bind();

        }

        private void bind()

        {

            con.Open();

            SqlDataAdapter da = new SqlDataAdapter("Select empID,empname from emp", con);

            DataTable dt = new DataTable();

            da.Fill(dt);

            DataRow dr;

            dr = dt.NewRow();

            dr.ItemArray = new object[] { 0, "---Select an item---" };

            dt.Rows.InsertAt(dr, 0);

            comboBox1.DisplayMember = "empname";

            comboBox1.ValueMember = "empID";

            comboBox1.DataSource = dt;

            con.Close();

        }

    }

}

Step4:
Now build the Solution and Debug it for the output.

OutPut :