How to Display Multiple column in a DropDownlist

Question

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.strMobilet blCustomer.strPhoneOff1t 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?

Bineesh Viswanath · Answer

Thank you all The issue has been solved. What I did is in property set AutoSizeItems = True

Bineesh Viswanath · Answer

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; }

Saravanan V · Answer

How are you binding the data into dropdown?

Nilesh Patil · Answer

I am not sure but change width of Dropdownlist