Bind ComboBox In Windows Application Using C#

Nilesh Jadav

22 Comments

Join the conversation! Your thoughts help the community grow.

Jiyaul Mustapha7y ago
Private void BindVendorDDL() { ddlVendor.Items.Clear(); DataTable dt = new DataTable(); dt = bl.BindCompanyDLL(); if (dt.Rows.Count > 0) { ddlVendor.Text = "--Select--"; for (int i = 0; i < dt.Rows.Count; i++) { ddlVendor.Items.Add(dt.Rows[i]["Vendor_name"].ToString()); } } }
akshay shakya8y ago
Awesome. way of explanation
ambati chawla9y ago
Will u please keep the properties of all the toolbox events in c-SharpCorner
- Nilesh Jadav9y ago
  I don't Understand it ? what does it mean ? Can you be more specific?
Ibrahim Wasiu9y ago
I rily grateful with the solution you share with us. God will crown your effort to success.
- Nilesh Jadav9y ago
  Thank you Ibrahim Wasiu I appreciate your feedback
Arul R11y ago
Good one !!!
- Nilesh Jadav11y ago
  Thank you Arul R
Santhakumar Munuswamy11y ago
Nice Article. Thanks for sharing
- Nilesh Jadav11y ago
  Thank you Santhakumar Munuswamy
Karthikeyan K11y ago
Good one sir...
- Nilesh Jadav11y ago
  Thank you Karthikeyan K
Vinodh Narayanan11y ago
nice share]
- Nilesh Jadav11y ago
  Thank you N Vinodh
Rakesh11y ago
Good one
- Nilesh Jadav11y ago
  Thank you Rakesh Chavda
Sujeet Suman11y ago
Good Article
- Nilesh Jadav11y ago
  Thanks Sujeet Suman
Harshad Pansuriya11y ago
Nice one
- Nilesh Jadav11y ago
  Thank you Harshad Pansuriya
Ankit Bansal11y ago
good one...
- Nilesh Jadav11y ago
  Thank you Ankit Bansal

We make one table and bind that data to our ComboBox.

Initial chamber

Step 1: Open Your Visual Studio 2010, Go to File, New, Projects and under Visual C#, go to Windows.

windows form application

You can change the name of the project and browse your project to different location too. And then press OK.

Step 2: In Solution Explorer you get your Project, Add Service Based Database. By going to your Project, Right Click and Add New Item, then Service Based Database.

Database chamber

Step 3: Get to your Database [Database.mdf], we will create a table tbl_Data. Go to the database.mdf, Table and Add New table. Design your table like this following:

Tbl_data:

table design

Show tbl_data:

table

Design chamber

Step 4: Now open your Form1.cs[Design] file, where we create our design for ComboBox Binding.

We will drag ComboBox from the tool box to Form1.cs [Design], you will see your Form look like the following:

Code chamber

Right Click on the blank part of Form1.cs, then View Code. You will see you entered in the code part of the form. Write the following code and then press F5 to run the project.

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 WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
refreshdata();
}
public void refreshdata()
{
DataRow dr;
SqlConnection con = new SqlConnection(@"Data Source=NiluNilesh;Initial Catalog=mynewdata;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from tbl_data", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
dr = dt.NewRow();
dr.ItemArray = new object[] { 0, "--Select Movie--" };
dt.Rows.InsertAt(dr, 0);
comboBox1.ValueMember = "id";
comboBox1.DisplayMember = "movie";
comboBox1.DataSource = dt;
con.Close();
}
}
}

Output chamber

Output

Hope you like this. Thank you for reading. Have a good day.