Assign More than one value to Combo box

Question

Hello ,

I have one combo box on my page .And I have assigned one data-table to it as Data source .

Now My data table has three columns , ID ,Short_ID,Title.And Data Text of my combo must be Short_ID.Title may contains any character and alpha numerical characters.

Now on Selected Index change event of Com-box , I want all three values.

IF I assign join ID and Title by any value and assign it to Data value field ,then it will create problem.

How can I solve This issue ?

-Thanks

narasimman g · Answer

I dont think dropdown can hold more than one value if you dont want to join and split why dont you place one more invisible dropdownlist if you have three values say A,B,C fetch dd1.DataTextField =A; dd1.DataValueField = B; //Invisible one dd2.DataTextField =C dd2.DataValueField = B; dd1.selectedvalue = "UserAssignedValue" //from button click dd2.selectedvalue = "UserAssignedValue"; So you wil get B and C from dd1 and dd2 resp in selectedValue; this may be the temporary workaround Since u dont want to iterate

Suthish Nair · Answer

I dont know if any other way there, wait for more replys.. if(value[0]==ID) { Li.Selected=true; break; }

Roy r · Answer

Suppose in page Load I've bind combo-box. So Now each items has TextField = "Short_ID" and ValueField ="ID + '~' + Title" ; Now Consider,on button click event I want to select one of the combobox item by ID(id that we have joined in value field). So I cant do it by following way if I join two items in value field. combox.selectedvalue=ID; To do so I've to iterate throught each items as follows : foreach(ListItem Li in Combo.Items) { string[] value=Li.value.split('~'); if(value[0]==ID) { Li.Selected=true; } }

Suthish Nair · Answer

Roy, Can you explain this line more: "Because each time when I want to select combo box item by "

Roy r · Answer

No.. Actually I do not want to join two values in such a way.. Because each time when I want to select combo box item by ID,then I will have to loop on combo box items and split the value and then have to do comparison of Ids. Is there any other way ,like I can inherit Drop down control and add some costume properties to it ?

Suthish Nair · Answer

Query resolved?

Suthish Nair · Answer

change your SQL select query like this.. example: select Short_ID, (ID + '~' + Title) "TitleID" from table Now combobox binding ddl.DataTextField = "Short_ID"; ddl.DataValueField = "TitleID"; Now on Selected Index change, get the selected value and split on '-'. ddl.SelectedValue.Split('~')[0] ddl.SelectedValue.Split('~')[1]