adding two ranges with range number to Drop Down List.

Question

0.00/5 (No votes)

See more:

Hi friends,

I am getting Range1 and Range2 from database. Dataset is like below.

Range1 Range2
AB100 XY200
AB300 XY400
AB500 XY600

I have to bind these ranges to a Drop Down List as list items includung range number in my application.
So list item should be like ==> 1 AB100 XY200 . When user selects a range I have to pass Range1 and Range2 to database.
How can I bind the two ranges with range number to Drop Down List.

Regards,
JN

Posted 22-Mar-11 0:40am

SRIRAM 2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mahendra.p25 · Answer 1 · 2011-03-22T02:18:00

Solution 3

hi

use Query like this

select Id,Range1+Range2 as Range from test

and then bind it to the dropdown like

MIDL

DropDownList1.DataSource = ds;
            DropDownList1.DataTextField = Convert.ToString(ds.Tables[0].Rows[0]["Range"]);
            DropDownList1.DataValueField = Convert.ToString(ds.Tables[0].Rows[0]["Id"]);
            DropDownList1.DataBind();

Posted 22-Mar-11 2:18am

Mahendra.p25

Comments

Ankit Rajput 22-Mar-11 8:39am

One more thing i want to add here.

Now you need to handle SelectedIndexedChanged Event to pass the values to the database.

Wayne Gaylard · Answer 2 · 2011-03-22T01:26:00

Why don't you create a separate struct, something like this:

C#

private struct RangeStruct
    {
        public string name;
        public string upperRange;
        public string lowerRange;
    }

then you can convert your dataset into a collection of RangeStruct and bind to that. Then when your user selects a range from your dropdownlist you have all the info you need.

m@dhu · Answer 3 · 2011-03-22T01:43:00

Solution 2

You can also populate the droplist using the query like

SQL

select cast(id as varchar) +' '+Range1+' '+Range2 as test from table1

While you pass to db split the Id and save the ranges.

Posted 22-Mar-11 1:43am

m@dhu