How to get the database table values into combobox??

Question

Satyapriya Nayak · Answer

Hi Backiyalakshmi, Try this... 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.OleDb; namespace Combobox { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; //OleDbDataAdapter oda; //DataSet ds; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { comboBox1.Items.Add("Choose employee"); OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from employee"; com = new OleDbCommand(str, con); OleDbDataReader reader = com.ExecuteReader(); while (reader.Read()) { comboBox1.Items.Add(reader["name"]); } } } } Thanks If this post helps you mark it as answer

backiyalakshmi K · Answer

hi satya thank u so much i got the result...

Kunal Vaishya · Answer

void Fillcombo() { string connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Administrateur\Mes documents\stockage.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; cn.ConnectionString = connectionString; cn.Open(); SqlDataAdapter d = new SqlDataAdapter("select nom_pdt from Produit", cn); DataTable dt = new DataTable(); d.Fill(dt); comboBox1.DataSource = dt; comboBox1.DisplayMember = "nom_pdt"; }

Kunal Vaishya · Answer

void Fillcombo() { string connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Administrateur\Mes documents\stockage.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; cn.ConnectionString = connectionString; cn.Open(); SqlDataAdapter d = new SqlDataAdapter("select nom_pdt from Produit", cn); DataTable dt = new DataTable(); d.Fill(dt); comboBox1.DataSource = dt; //comboBox1.DataBindings.ToString(); }

How to get the database table values into combobox??

Answers (4)