how to solve Cannot bind to the new display member parameter

I created a window for along with my lined database while I am started debugging my code it showing error like "Cannot bind to the new display member parameter name: new Display member"...

Here is the Code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsFormsApplication5
{
public partial class Form2 : Form
{
DataTable dt = new DataTable();
static string connection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\db\\MobileSpec.mdb;";
OleDbConnection conn = new OleDbConnection(connection);
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
DataTable dtable = new DataTable();
string sql = "select Distinct Price from mobilelist";
DataTable dtable1 = new DataTable();
string sql1 = "select Distinct Storage from mobilelist";
DataTable dtable2 = new DataTable();
string sql2 = "select Distinct Storage from mobilelist";
try
{
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
da.Fill(dtable);
dtable.Columns.Add("select Ram");
comboBox1.DataSource = dtable;
comboBox1.DisplayMember = "Desc";
comboBox1.ValueMember = "Ram";
comboBox1.SelectedValue = "select Ram";
OleDbDataAdapter da1 = new OleDbDataAdapter(sql1, conn);
da1.Fill(dtable1);
dtable1.Columns.Add("select Storage");
comboBox2.DataSource = dtable1;
comboBox2.DisplayMember = "Storage";
comboBox2.ValueMember = "Storage";
comboBox2.SelectedValue = "select Storage";
OleDbDataAdapter da2 = new OleDbDataAdapter(sql2, conn);
da2.Fill(dtable2);
dtable2.Columns.Add("select Battery mAh");
comboBox3.DataSource = dtable2;
comboBox3.DisplayMember = "Battery mAh";
comboBox3.ValueMember = "Battery mAh";
comboBox3.SelectedValue = "select Battery mAh";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
conn.Close();
}
}
}

3 Replies

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

Nitin Sontakke8y ago
Please ONLY paste the relevant select statements that you have modified.

Honestly, just saying 'it doesn't work' doesn't help much.
+1
Aruljothy Sundaramoorthy8y ago
I Gave the column name in the select statement but it's not working
+2
Nitin Sontakke8y ago
DisplayMember and ValueMember must be the column names from your select statement. They subsequently become columns in your dataTable, which is used as a data source. Hope you understand.

I don't see absolutely any relation between what you are selecting and what you are setting as DisplayMember and ValueMember.
+1