Assign More than one value to Combo box

Roy r

15y15.6k.NET

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

7 Replies

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

narasimman g15y ago
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
0
Suthish Nair15y ago
I dont know if any other way there, wait for more replys..
```
 if(value[0]==ID) { Li.Selected=true; break; }
```
0
Roy r15y ago
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; }
}
0
Suthish Nair15y ago
Roy,
Can you explain this line more:
"Because each time when I want to select combo box item by "
0
Roy r15y ago
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 ?
0
Suthish Nair15y ago
Query resolved?
0

Suthish Nair15y ago

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]