combobox error

anil john

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
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(); } } }
0
Priya Linge14y ago
Hi,
I bind combobox as follow,
Dataset ds=new Dataset();
DataTable dt;
string query="Select Emp_ID,Emp_name from Employee;
sqlcommand cmd=new sqlcommand(query,con);
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.
0
Satyapriya Nayak14y ago
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"]); } } } }
0