How to display two different columns in one combobox c#

Jyoti Jodha

How to display two different columns in one combobox windows form c#

DataRow dr;

con.Open();

SqlCommand cmd = new SqlCommand("select Product_ID,Name,Bar_Code from Product", con);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

sda.Fill(dt);

dr = dt.NewRow();

dr.ItemArray = new object[] { 0, "--Select Product--" };

dt.Rows.InsertAt(dr, 0);

comboBoxproduct.ValueMember = "Product_ID";

comboBoxproduct.DisplayMember = "Name" or "Bar_Code";

comboBoxproduct.DataSource = dt;

con.Close();

10 Replies

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

Rafnas T P9y ago
Accepted answer
sorry
try this
select Product_ID,case when Name is not null or Name ! = '' then Name
else Bar_Code end as Name from Product
0
Jyoti Jodha9y ago
Now Error Show Like This..

Incorrect syntax near the keyword 'is'.
0
Rafnas T P9y ago
try this

select Product_ID,case Name is not null and Name ! = '' then Nameelse Bar_Code end as Name from Product
0
Jyoti Jodha9y ago
Error Show Like This
"Incorrect syntax near '!'."
0
Rafnas T P9y ago
hi
change your query with this
select Product_ID,case Name!=null and Name!='' then Name
else Bar_Code end as Name from Product
then bind
comboBoxproduct.DisplayMember = "Name"
0
Jyoti Jodha9y ago
how to create case condition in this Query....??
0
Rafnas T P9y ago
if you wanted to show bar code if name is not there
then in query you can give case condition and give as one column, bind this column
0
Rafnas T P9y ago
hi,

you cannot bind two column at a time
0
Jyoti Jodha9y ago
Don't Show Records.....
0
Ravi Patel9y ago
Hi ,

try this

DataRow dr;
con.Open();
SqlCommand cmd = new SqlCommand("select Product_ID,Name,Bar_Code from Product", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
dr = dt.NewRow();
dr.ItemArray = new object[] { 0, "--Select Product--" };
dt.Rows.InsertAt(dr, 0);
comboBoxproduct.ValueMember = "Product_ID";
comboBoxproduct.DisplayMember = "Name" +"or"+ "Bar_Code";
comboBoxproduct.DataSource = dt;
con.Close();
0