How To get Value Between Two drop down list

prince raj

12y1.3kLearn iOS Programming

i have two Dropdown list

From

Any

VVS1

VVs2

VS1

VS2

SI1

SI2

SI3

Any

VVS1

VVs2

VS1

VS2

SI1

SI2

SI3

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 = "FL,IF,VVS1,VVs2,VS1,VS2,SI1,SI2,SI3,I1,I2";

How can i ?

Thanks in advance.

4 Replies

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

Vasu Gadhiya12y ago
Accepted answer
Very Simple

-----------------
String Values = "";

if(dropdownFrom.Text == "Any" || dropdownTo.Text == "Any")
{
Values = "Any";
}
else
{
for(int i = dropdownFrom.SelectedIndex; i <= dropdownTo.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".
0
prince raj12y ago
Thanks
0
prince raj12y ago
i want to need in String Format like
string values = "FL,IF,VVS1,VVs2,VS1,VS2,SI1,SI2,SI3,I1,I2";
0
sudipta sanyal12y ago
CREATE TABLE #temp_list (id INT IDENTITY(1,1),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 <= @in_to_id
ORDER BY id ASC -- MUST USE ORDER BY

SELECT @combined
------------------------------------
DROP TABLE #temp_list
0