How to bind dropdown list

Question

3.50/5 (2 votes)

See more:

C#

 DataTable dtCurrentTable = new DataTable
for (int i = 0; i < dtCurrentTable.Rows.Count; i++)
 {
    DropDownList ddltype =
    (DropDownList)gvFormula.Rows[rowIndex].Cells[1].FindControl("ddltype");


     ddlproduct.SelectedItem.Text = dtCurrentTable.Rows[i]["ddltype"].ToString();
     rowIndex++;
 }

When I assign dropdown list value . Its showing only one value.
My requirement is to bind all the values in dropdown list when selected

Posted 3-Oct-13 3:10am

Bhagavan Raju M

Updated 3-Oct-13 17:11pm

v3

Add a Solution

Comments

thatraja 3-Oct-13 9:31am

Your code is confusing little bit, you have 2 dropdownlists, right? where's is it? are you trying to implement nested dropdownlist like country-state?

Bhagavan Raju M 3-Oct-13 23:19pm

@thatraja (It is in gridview )I have date field ,every day the values must entered in that I have a dropdown list . when the user click save button the values are inserting into DB.But problem is after inserting i have display the values wrt to their controls. But dropdownlist is not binding

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 3-Oct-13 23:35pm

Still not clear. Can you elaborate again?

5 solutions

Solution 2

visit here..

how to bind dropdownlist[^]

or

How to bind or populate data into a Dropdown List based on first or another Dropdown List in Asp.net C#[^]

Posted 3-Oct-13 3:28am

Rakesh Meel

Solution 3

try it hope it will work:

C#

DropDownList ddltype =
    (DropDownList)gvFormula.Rows[rowIndex].Cells[1].FindControl("ddltype");
       DataTable dtCurrentTable = new DataTable
for (int i = 0; i < dtCurrentTable.Rows.Count; i++)
 {
ddlproduct.Items.Insert(i,new ListItem( dtCurrentTable.Rows[i]["product"].ToString(), dtCurrentTable.Rows[i]["product"].ToString()));

}

Posted 3-Oct-13 15:40pm

Ajay_Saini

Updated 4-Oct-13 2:20am

v3

Solution 4

You need to find out Cascading dropdown in ajax or u can check it on google

www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/CascadingDropDown/CascadingDropDown.aspx"

www.webcodeexpert.com/2013/07/ajax-cascadingdropdown-example-in.html

this might be useful to you

Posted 3-Oct-13 18:15pm

indrajeet jadhav

Solution 6

by two way
Suppose Datatable is dt and your datat into it.
assume Dropdownlist dr;
//ASP.NET Code
dr.DataSource=dt;
dr.DataTextField="colname";

or
for (int i=0;i<dt.rows.count;i++)>
{
dr.Items.Add(dt.Rows[i]["colname"].ToString());
}

Posted 4-Oct-13 2:38am

Abid Shk

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)

vipul19189 · Accepted Answer · 2013-10-04T02:00:00

Solution 5

C#

DataSet ds = new DataSet();
     SqlDataAdapter da = new SqlDataAdapter("Select distinct(name)from employee", connection);
     da.Fill(ds);
     drpemployee.DataSource = ds;
     drpemployee.DataValueField = "name";
     drpemployee.DataBind();
     drpemployee.Items.Insert(0, "--Select--");

Posted 4-Oct-13 2:00am

vipul19189

Updated 4-Oct-13 2:19am

v3