How To get Value Between Two drop down list

Question

i have two Dropdown list From Any FL IF VVS1 VVs2 VS1 VS2 SI1 SI2 SI3 I1 I2 I3 To Any FL IF VVS1 VVs2 VS1 VS2 SI1 SI2 SI3 I1 I2 I3 Now if User Select 'FL' in From and 'I2' in To than i need All Value in between two selected parameter. like string values = FLIFVVS1VVs2VS1VS2SI1SI2SI3I1I2; How can i ? Thanks in advance.

Vasu Gadhiya · Answer

Very Simple ----------------- String Values = ; if(dropdownFrom.Text == Any || dropdownTo.Text == Any) { Values = Any; } else { for(int i = dropdownFrom.SelectedIndex; i { Values +=  + dropdownFrom.Items[i].Text.ToString(); } // To remove First  Values = Values.Substring(1 Values.Length - 1); } //Print Values ----------------------- But One Problem You may be face that if User select smaller value in dropdownTo and larger value in dropdownFrom.

prince raj · Answer

Thanks

prince raj · Answer

i want to need in String Format like string values = FLIFVVS1VVs2VS1VS2SI1SI2SI3I1I2;

sudipta sanyal · Answer

CREATE TABLE #temp_list (id INT IDENTITY(11)name NVARCHAR(20)) INSERT INTO #temp_list VALUES ('Any') INSERT INTO #temp_list VALUES ('FL') INSERT INTO #temp_list VALUES ('IF') INSERT INTO #temp_list VALUES ('VVS1') INSERT INTO #temp_list VALUES ('VVs2') INSERT INTO #temp_list VALUES ('VS1') INSERT INTO #temp_list VALUES ('VS2') INSERT INTO #temp_list VALUES ('SI1') INSERT INTO #temp_list VALUES ('SI2') INSERT INTO #temp_list VALUES ('SI3') INSERT INTO #temp_list VALUES ('I1') INSERT INTO #temp_list VALUES ('I2') -------BY THIS YOU CAN POPULATE YOUR FROM AND TO DROPDOWN SELECT * FROM #temp_list ORDER BY id ASC -- MUST USE ORDER BY -------- /* After that write a proc or funcation and pass the from_selected_id and to_selected_id */ DECLARE @in_from_id INT @in_to_id INT SELECT @in_from_id = 2  @in_to_id = 10 DECLARE @combined VARCHAR(MAX) SELECT @combined = isnull(@combined + '''') + isnull(name'') FROM #temp_list WHERE id > = @in_from_id AND id ORDER BY id ASC -- MUST USE ORDER BY SELECT @combined ------------------------------------ DROP TABLE #temp_list