retrieving data into dropdownlist control from table in back end

Question

0.00/5 (No votes)

See more:

Not getting the dropdown control on the form updated from table in the backend

1. Id No: txt_Id

2. Name : txt_Name

3 Gender : ddl_Gender

The gender is a drop down that has male/female as the options embedded

Table :: Trial

Idno Name Gender
------------------------
01 Paul male
02 Ivy female
03 Sal female

All the other controls work with the exception of the drop down.

Checked on the internt for the solution. The examples were not very clear.

Please provide sample codes or a good reference

Thanks

new to C#

Posted 27-Jun-14 20:07pm

Member 10744248

Updated 27-Jun-14 20:51pm

v4

Add a Solution

Comments

Pravuprasad 28-Jun-14 2:14am

i am not getting your problem.Please explain these.
From the above 3 values what u retrieve from database and what you want to populate in dropdown?

Member 10744248 28-Jun-14 2:28am

All 3 fields which are records on 'select' from gridview which is on the form.

All the field work with the exception of the dropdown control

1 solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2014-06-27T20:51:00

Solution 1

You should have two items declared for the DropDownList that are male and female.

As you are having directly stored male and female as strings, so you can declare the DropDownList items with value as male and female.

Now, when you retrieve the value from Database, you get either male or female for a particular row. Then just assign that as the SelectedValue property of the DropDownList so that correct option gets selected.

Posted 27-Jun-14 20:51pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Member 10744248 28-Jun-14 3:38am

Please provide a simple example , new to C#, moving from visual foxpro

Thanks

Member 10744248 28-Jun-14 3:40am

or a refernce

Where is the Selectedvalue property