Multi Column in a DropDown

[Ajeet mittal]

Hi, My project is in asp.net 2.0 with c#. In my project I have to display Multi Column in a single dropdown. like name and address on one dropdown. Can any one tell me how i can do it. thanks

[Abhijit Jana]

Check This MultiColum Dropdown List in Codeproject[^]

cheers, Abhijit

[Sherin Iranimose]

Multi column in asp.net Dropdown[^]

[eyeseetee]

I call it a draw between the two of you!! I would prefer to use the listbox as the multi column dropdwonlist isnt a custom control

[Ajeet mittal]

Thanks for replying me. i gone through that articles. but i wont get solution exectly. as they uses third party control. also with that control i am unable to bind text value field. actully i have to show some text and during saving it to data base i have to store value which is index field. with third party control i am not getting it. so that i am unable to solve my problem. can u please help me.

[eyeseetee]

I dotn think there is another way to do it The dropdowlist is not really designed for multi columsn. Why not try a different method like a listbox?

[Ajeet mittal]

Can u tell me how i can show it with list box.

[Sherin Iranimose]

Yes you are right... And There are 100s ways doing this. Did you check the answer,That I've given? :)

[eyeseetee]

What do you mean? :)

[Blue_Boy]

I suggest you to select multiple columns in t-sql statement and cast as single column,then bind dropdownlist with that query. Example: T-SQL Query Select column1+' '+ Column2+' ' +column3 as MultipleColumns from TableName Binding DropDownList DropDownList1.DataValueField = "ColumnName"; DropDownList1.DataTextField = "MultipleColumns "; Hope this will give you an idea.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you."

[Ajeet mittal]

Thanks For replying me. I did check it. but my problem is not solved. if possible tell me solution. thanks