DropDown List AsP.net

Question

0.00/5 (No votes)

See more:

Hello,

-I have 2 drop down lists in asp.net. one contain S.no and the other one contains the name. that are stored in SQL Server.

-I just want to that when I select the s.no from the 1st drop down list it automatically selects the name in the in the 2nd drop down list.. which is already stored in SQL Server

-SQL Table fields contains

S.NO|Name|fName

Thanks,
xibit89

Posted 20-Aug-13 1:13am

xibit89

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 20-Aug-13 7:16am

So, what have you tried?

xibit89 20-Aug-13 7:19am

I don't understand the logic. I haven't tried anything yet.

ZurdoDev 20-Aug-13 7:20am

1. Reply to the comment so that the user is notified.
2. Since you haven't done anything you should search for an example online and try to implement it. Giving you all of the code is not likely going to happen.

Jignesh Khant 20-Aug-13 7:22am

Bind first drop down's text and value both with your srno field from db and keep autopostback onn. For second dropdown bind value with srno and text with name. Then on selected index change of first dropdown change the value of second dropdown.

xibit89 20-Aug-13 7:23am

private void BindComb(string ddlName)
{
if (ddlsno == "ddlsno")
{
DataTable dt = new DataTable();
dt = dl.getsno();
ddlsno.DataSource = dt;
ddlsno.DataTextField = "sno";
ddlsno.DataValueField = "Name";
ddlsno.DataBind();
}
else if (ddlName == "ddlName")
{
DataTable dt = new DataTable();
dt = dl.getName();
ddlName.DataSource = dt;
ddlName.DataTextField = "Name";
ddlName.DataValueField = "sno";
ddlName.DataBind();
}

this I have done for data bound

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 20-Aug-13 7:27am

In dt = dl.getName(); what is "dl" here?

xibit89 22-Aug-13 7:27am

data layer

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 22-Aug-13 7:44am

Okay... :)

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 (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-08-20T01:46:00

Logic

Use OnSelectedIndexChanged Method[^] of DropDownList.
Get the Selected Value.
Loop through the DataTable and find the Row where it has that Selected Value (S.No).
Get required column value (the DropDown value, which need to be selected) in that Row.
Select other DropDown by the value we got in previous step.