How to Display Multiple column in a DropDownlist

Bineesh Viswanath

Sir,

I am currently in a situation where unable to fill multiple database column into a dropdownlist.

full value is not displaying in the last

This is how dropdown displaying. See the screenshot below:-

actually there are more values in columns.

Select tblCustomer.strMobile,t blCustomer.strPhoneOff1,t blCustomer.strPhoneRes, tblCustomer.strFax from tblCustomer where tblCustomer.strCustomerID='0.2000000'

kindly pardon as I not like to put here exact number from the database. the result looks like this :-

why this happening?

4 Replies

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

Bineesh Viswanath9y ago
Thank you all,

The issue has been solved.

What I did is in property, set AutoSizeItems = True

0
Bineesh Viswanath9y ago
if (dtbl.Rows.Count > 0)
{
dtbl.Columns.Add("Number", typeof(System.String));
DataRow drow = dtbl.NewRow();
drow["Number"] = dtbl.Rows[0]["strMobile"].ToString();
dtbl.Rows.Add(drow);
drow = dtbl.NewRow();
drow["Number"] = dtbl.Rows[0]["strPhoneOff1"].ToString();
dtbl.Rows.Add(drow);
drow = dtbl.NewRow();
drow["Number"] = dtbl.Rows[0]["strPhoneRes"].ToString();
dtbl.Rows.Add(drow);
drow = dtbl.NewRow();
drow["Number"] = dtbl.Rows[0]["strFax"].ToString();
dtbl.Rows.Add(drow);
ddlCustomerPhone.DataSource = dtbl;
ddlCustomerPhone.DisplayMember = "Number";
}
0
Saravanan V9y ago
How are you binding the data into dropdown?
0
Nilesh Patil9y ago
I am not sure but change width of Dropdownlist
0