How to slove this prob in Drop Down List

Question

0.00/5 (No votes)

See more:

Hi, All

Here my prob is, i insert male and female in dropdown list and how can i retrive the data from DB

For Ex:

SQL

ddlgender.Items.Insert(0, new ListItem("--Select--", ""));
           ddlgender.Items.Insert(1, new ListItem("Male", "1"));
           ddlgender.Items.Insert(2, new ListItem("FeMale", "2"));

i insert this item to DDL when user save to DB how can i retrieve that item in dropdown list, if user save male item means i want show female also but male want to selected item=true;

Posted 19-Aug-14 22:47pm

prasanna.raj

Add a Solution

Comments

Ashi0891 20-Aug-14 4:51am

lemme try to understand you want to save the selected drop downlist item into database for respective entry?

Ashi0891 20-Aug-14 5:28am

From what i could get, you want to add selected data from dropdownlist into database to respective entry. And at the time when you show the data you want to show all the items of dropdownlist and the one which was selected and is added in the table data should be selected or be highlighted. Is it so?

prasanna.raj 20-Aug-14 6:58am

yes..

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)

Gupta Poonam · Answer 1 · 2014-08-19T22:59:00

Solution 2

You can use SelectedIndex property..

C#

ddlgender.SelectedIndex=1 // for Male
ddlgender.SelectedIndex=2 // for Female

Posted 19-Aug-14 22:59pm

Gupta Poonam

Updated 19-Aug-14 23:00pm

v2

Comments

prasanna.raj 20-Aug-14 5:11am

how we know index number which they selected...

Gupta Poonam 20-Aug-14 5:16am

int index= ddlgender.SelectedIndex // To get SelectedIndex
int value=(Convert.ToInt32(ddlgender.SelectedValue)) // To get SelectedValue

prasanna.raj 20-Aug-14 6:58am

thanks Gupta..

Prakriti Goyal · Answer 2 · 2014-08-20T01:01:00

Hello,

As per your problem,

1. User selects the gender
2. The selected value gets stored in the database.
3. Now if you want to :

- Display the dropdownlist with the selected value:

ddlGender.Items.FindByText(<here put="" the="" value="" coming="" from="" database="">).Selected = true;</here>

- If you want to get the selected text:

ddlGender.SelectedItem.Text

- If you want to get the selected value:

ddlGender.SelectedItem.Value

- If you want to get the selected index:

ddlGender.SelectedIndex

Hope this helps you :)

Kumarbs · Answer 3 · 2014-08-19T22:55:00

Solution 1

You can try this.

SQL

ddlgender.SelectedIndex =
    ddlgender.Items.IndexOf(ddlgender.Items.FindByValue("Male"))

Posted 19-Aug-14 22:55pm

Kumarbs

Comments

prasanna.raj 20-Aug-14 6:58am

thanks Kumarbs

Kumarbs 20-Aug-14 7:06am

If this solves your prob accept this as a solution.

How to slove this prob in Drop Down List

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us