combobox error

Question

I am getting an error while filling combobox values during the time when i read values from database table to the combobox Error: cannot bind to the new display member. parameter name newdisplaymember

Satyapriya Nayak · Answer

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.IO; using System.Collections; using System.Data.OleDb; namespace WindowsFormsApplication5 { 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.Text=--Select--; OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from cat; com = new OleDbCommand(str con); oda = new OleDbDataAdapter(com); ds = new DataSet(); oda.Fill(ds cat); comboBox1.Items.Clear(); comboBox1.DataSource = ds.Tables[cat]; comboBox1.ValueMember = categoryid; comboBox1.DisplayMember = category; con.Close(); } } }

Priya Linge · Answer

Hi I bind combobox as follow Dataset ds=new Dataset(); DataTable dt; string query=Select Emp_IDEmp_name from Employee; sqlcommand cmd=new sqlcommand(querycon); sqlDataAdapter da=new sqlDataAdapter(); da.SelectCommand = cmd; da.fill(ds); dt=ds.Tables[0]; CmbEmpName.ValueMember = Emp_ID CmbEmpName.DisplayMember = Emp_name CmbEmpName.DataSource = dt; I set the DisplayMember and ValueMember before setting the DataSource. Hope this will help you. Thanks.

Satyapriya Nayak · Answer

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 CourseID); OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from Courses; com = new OleDbCommand(str con); OleDbDataReader reader = com.ExecuteReader(); while (reader.Read()) { comboBox1.Items.Add(reader[CourseID]); } } } }