To bind data to ComboBox in Windows forms follow the
steps below:
First Design form with One ComboBox from toolbox in
visualstudio.
Then write one ComboBoxBind() method in code behind
side and call that method in form load.
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=naresh;Initial Catalog=employee;User
ID=sa;Password=123");
public Form1()
{
InitializeComponent();
ComboBoxBind ();
}
private void ComboBoxBind ()
{
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();
}
}
}
Then run the application
and see the data will be bind to ComboBox.
OutPut :
This post is not working in my case.
ReplyDeleteMuhammad Usama Masood
m-usama-m.blopspot.com
it worked use has it is
ReplyDeleteHi try this..http://www.codingresolved.com/discussion/58/how-to-fill-combobox-from-database-in-c-sharpc
ReplyDeletecomboBox1.ValueMember = "empID";
ReplyDeleteit's not working for me.
it takes default combobox indexes .
Its working fine for me. Very very thanks to naresh
ReplyDelete