how to populate data in dropdowlist from database?

Question

1.00/5 (2 votes)

See more:

i have 3 tables
1. state(state_id,state_name) state_id PK,Identity specification
2.city (city_id,city_name.state_id) city_id

Posted 1-Feb-13 23:30pm

shivani 2013

Add a Solution

Comments

OriginalGriff 2-Feb-13 5:34am

And?
You forgot the question!
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

[no name] 2-Feb-13 5:41am

Seems you've not read question in Subject...

shivani 2013 2-Feb-13 6:30am

i am sorry i couldnt write whole code,,sry for ur valuable time .pls see that

[no name] 2-Feb-13 6:57am

Elaborate it..

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)

Naveen.Sanagasetti · Answer 1 · 2013-02-01T23:37:00

Your Question is not clear. But as per my understanding you want to bind the database values to DropDownList..? right...?

for that fetch the information from DataBase , and then store that information in DataSet and bind that DataSet to DropDownList.

Ex:

C#

DataSet ds=// fetch Data from DB;

ddl.DataSource=ds;
ddl.DataTextField="Name";
ddl.DataValueField="Id";
ddl.DataBind();

if you want more information regarding this you can search in google.
In google you get more results regarding this topic...

Krunal Rohit · Answer 2 · 2013-02-01T23:40:00

Solution 2

C#

// This is I've done for Document Type, based on it you can do it for your own query.

EditDocTypeDropDown.DataSource = bc.FillDocTypeDropDown();  // Fetch value for DropDown from Database
EditDocTypeDropDown.DataValueField = "type_id";
EditDocTypeDropDown.DataTextField = "type";
EditDocTypeDropDown.DataBind();

Posted 1-Feb-13 23:40pm

Krunal Rohit

Comments

shivani 2013 2-Feb-13 6:30am

i am sorry i couldnt write whole code,,sry for ur valuable time .pls see that

vivek511 · Answer 3 · 2013-02-02T20:57:00

SqlDataSource sqlDS = new SqlDataSource();
        sqlDS.ConnectionString = ConfigurationManager.ConnectionStrings[0].ToString();
        sqlDS.SelectCommand = "select state_id,state_name from State";
        form1.Controls.Add(sqlDS);

        DropDownList ddl = new DropDownList();
        ddl.ID = "dddlState";
        ddl.DataSource = sqlDS;
        ddl.DataTextField = "state_name";
        ddl.DataValueField = "state_id";
        form1.Controls.Add(ddl);

on the Change Index event of dd1 you can put the code

SqlDataSource sqlDS = new SqlDataSource();
        sqlDS.ConnectionString = ConfigurationManager.ConnectionStrings[0].ToString();
        sqlDS.SelectCommand = "select city_id,city_name from city where state_id='+dddlState.Value.Text()+"'";
        form1.Controls.Add(sqlDS);

        DropDownList dd2 = new DropDownList();
        dd2.ID = "dddlCity";
        dd2.DataSource = sqlDS;
        dd2.DataTextField = "City_name";
        dd2.DataValueField = "city_id";
        form1.Controls.Add(dd2);

how to populate data in dropdowlist from database?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0