for loop for many dropdownlist

Question

0.00/5 (No votes)

See more:

C#

SqlDataAdapter da1 = new SqlDataAdapter("select * from vehicle_category", con);
                DataTable dt1 = new DataTable();
                da1.Fill(dt1);
                ddlvnameri1.DataSource = dt1;
                ddlvnameri1.DataTextField = "vehicle_name";
                ddlvnameri1.DataValueField = "vehicle_id";
                ddlvnameri1.DataBind();
                ddlvnameri2.DataSource = dt1;
                ddlvnameri2.DataTextField = "vehicle_name";
                ddlvnameri2.DataValueField = "vehicle_id";
                ddlvnameri2.DataBind();

here i have filled data in only 2 dropdown list. i have to fill 10 dropdown list.
so how to write for loop for dis

Posted 16-Mar-13 0:04am

Member 9671810

Updated 16-Mar-13 0:08am

Mohamed Mitwalli

v2

Add a Solution

2 solutions

Solution 1

foreach (Control ctrl in this.Controls)<br />
            {<br />
             <br />
               if (ctrl.GetType().Name == "ComboBox")<br />
                {<br />
                    ComboBox cmb = (ComboBox)ctrl;<br />
                    cmb.DataSource = dt1;<br />
                cmb.DataTextField = "vehicle_name";<br />
                cmb.DataValueField = "vehicle_id";<br />
                cmb.DataBind();<br />
                }<br />
            }<br />

Use this if you want to fill same data in all you ddl on a form..
else use some condition like name checking etc..

Posted 16-Mar-13 0:22am

aankur81

Comments

Member 9671810 16-Mar-13 6:45am

why to use combo box

aankur81 16-Mar-13 7:42am

Drop down list termed as combobox

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)

Chinmaya C · Accepted Answer · 2013-03-16T07:00:00

Solution 2

Try with the following:

C#

DropDownList[] arr = { ddlvnameri1, ddlvnameri2, ... };  //list of all dropdownlists.
foreach (var d in arr)
{
    d.DataSource = dt1;
    d.DataTextField = "vehicle_name";
    d.DataValueField = "vehicle_id";
    d.DataBind();
}

Posted 16-Mar-13 7:00am

Chinmaya C

Comments

Member 9671810 16-Mar-13 13:17pm

not working .. :(

Chinmaya C 16-Mar-13 13:20pm

are you getting any error message?

Member 9671810 16-Mar-13 13:28pm

no the data is not getting bind

DropDownList[] arr = {ddlvnameri1, ddlvnameri2 };

foreach (var d in arr)
{
DataTable dt = new DataTable();
d.DataSource = dt;
d.DataTextField = "vehicle_name";
d.DataValueField = "vehicle_id";
d.DataBind();
}

i wrote dis code for the code what i have asked.

Chinmaya C 16-Mar-13 13:32pm

actually you are creating a blank DataTable in the for loop, which is getting binded with dropdowns, so no data is displayed...

I have modified your cde... please try with the following ...

SqlDataAdapter da1 = new SqlDataAdapter("select * from vehicle_category", con);
DataTable dt = new DataTable();
da1.Fill(dt);

DropDownList[] arr = {ddlvnameri1, ddlvnameri2 };
foreach (var d in arr) {
d.DataSource = dt;
d.DataTextField = "vehicle_name";
d.DataValueField = "vehicle_id";
d.DataBind();
}

Member 9671810 16-Mar-13 13:37pm

hehe.. i forgot that i have to fill datatable...

thanx...a lot...... :P

Chinmaya C 16-Mar-13 13:37pm

;)

Member 9671810 16-Mar-13 13:45pm

bt how can i solve dis problem using for loop

Chinmaya C 16-Mar-13 13:53pm

which problem you are talking about??

Member 9671810 16-Mar-13 13:56pm

as you solved my problem using foreach loop so how can i solve dis using for loop

Chinmaya C 16-Mar-13 14:00pm

DropDownList[] arr = { ddlvnameri1, ddlvnameri2 };

for (int i = 0; i < arr.Length;i++ ) {
arr[i].DataSource = dt;
arr[i].DataTextField = "vehicle_name";
arr[i].DataValueField = "vehicle_id";
arr[i].DataBind();
}

Member 9671810 16-Mar-13 14:03pm

okes... thanx a lot... :) :D