At a page i have 1 dropdown and the name of the companies are binded in that....& read in details below

Question

0.00/5 (No votes)

See more:

At a page i have 1 dropdownlist and the name of the branches are binded in that and i want that the details of the branch should be shown in the gridview according to the selection from dropdownlist.....so how it can possible and i want that the name of company should be in dropdown and data should be shown according to branch_id because company name can be same............answer plz

Posted 7-Oct-11 20:06pm

pallavi ajin

Add a Solution

2 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)

Syed Salman Raza Zaidi · Answer 1 · 2011-10-07T20:10:00

Solution 1

Hi,
you need to bind dropdown some thing like this

C#

query="select branchid,compname from table";

//execute it

Dropdown.Datasource=//give datasource

dropdown.DataTextField="compname";
dropdown.DataValueField="branchid";

then on selectedindex changed use this

query="select * from table where branchid="+dropdown.SelectedValue;

Hope you have understand :)

Posted 7-Oct-11 20:10pm

Syed Salman Raza Zaidi

Updated 7-Oct-11 21:05pm

v2

Comments

pallavi ajin 8-Oct-11 2:33am

thnx its working

pallavi ajin 8-Oct-11 2:45am

but 1 more thing on that page its showing data.nw i want to insert that br_id,br_name into table along with others values.for the insertion of br_id i m using ddl.SelectedValue()and wht will i use for name ???may i use selectedItem()?and will i have to convert ddl.selectedvalue into integer????

hitech_s · Answer 2 · 2011-10-07T20:26:00

XML

<asp:DropDownList id="dropdown1" runat="server" OnSelectedIndexChanged="ddlBranch_SelectedIndexChanged" >
<asp:ListItem value="0">--select--

dropdown binding should be like this

C#

ddlBranch.DataSource = datatable;//datatable that contains branch names and branch id's
           ddlBranch.DataTextField = "BRANCH_NAME";
           ddlBranch.DataValueField = "BRANCH_ID";
           ddlBranch.DataBind();

in selectedindexchanged event of dropdown write the following

C#

protected void ddlBranch_SelectedIndexChanged(object sender, EventArgs e)
    {
string query ="select * from branchtable where branchid="+ddlBranch.SelectedValue;
SqlConnection sqlConn = new SqlConnection("your connection string");
SqlDataAdapter sqlAdapter = new SqlDataAdapter(query , sqlConn);
Dataset ds=new Dataset();
sqlAdapter.Fill(ds);
gridview1.datasource=ds.Tables[0];
gridview1.databind();
}