How to bind dataset values into itemtemplate dropdown control in gridview

Question

0.00/5 (No votes)

See more:

The item template column control is dropdown in gridview. dataset values will binded into that dropdown control
i have written code into the page load Event

DataSet ds = new DataSet();
ds = GetDataValue();//This line get values from the database
GrdEmploye.DataSource = ds;
GrdEmploye.DataBind();
int i = 0;
DropDownList Drp;
foreach (GridViewRow RowItem in GrdEmploye.Rows)
{ 
    Drp = (DropDownList)(RowItem.Cells[0].FindControl    ("DrpEmployee"));//This line is denote the item template column control
    Drp.DataSources= ds;
    Drp.DataTextField  = ds.Tables[0].Rows[i]["Empsap"].ToString();
    Drp.DataValueField = ds.Tables[0].Rows[i]["Empsap"].ToString();
    Drp.DataBind();//This line got error
}

Posted 16-Dec-10 0:00am

Anbuselvan_83

Updated 16-Dec-10 1:28am

Abdul Quader Mamun

v4

Add a Solution

Comments

Ankur^\m/ 16-Dec-10 6:15am

What error?

Abdul Quader Mamun 16-Dec-10 7:28am

Spelling check.

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)

Hiren solanki · Answer 1 · 2010-12-16T01:41:00

Many suggestion to avoiding error.

Drp.DataSources= ds;

Rather then binding whole dataset to Drp. just bind the specific table inside.

Like ds.Tables["sometablename"];

Drp.DataTextField = ds.Tables[0].Rows[i]["Empsap"].ToString();
Drp.DataValueField = ds.Tables[0].Rows[i]["Empsap"].ToString();

Here you just need to assign specific table column name rather then dynamic row value data.<clear>

For Example are if you're sure that table have column, suppose "Fees" then bind it with.

Drp.DataTextField = "Fees";

Same holds true for DataValueField.

And If you aren't sure with the column name, then just fetch column name from table Like

Drp.DataTextField = dt.Tables[0].Columns[2].ColumnName

Please vote and Accept Answer if it Helped.

Member 11344378 · Answer 2 · 2015-04-11T23:44:00

Solution 3

Try This

DropDownList ddl;
int i = 0;
foreach (GridViewRow grdrow in grdmenu.Rows)
{
ddl = (DropDownList)grdmenu.Rows[grdrow.RowIndex].FindControl("ddloffer");
ddl.SelectedIndex = Convert.ToInt16(ds.Tables[0].Rows[i]["Offer"]);
ddl = (DropDownList)grdmenu.Rows[grdrow.RowIndex].FindControl("ddloffers");
ddl.SelectedIndex = Convert.ToInt16(ds.Tables[0].Rows[i]["OfferType"]);
i++;
ddl.DataBind();
}

Posted 11-Apr-15 23:44pm

Member 11344378

Updated 11-Apr-15 23:46pm

v2

Comments

lapislaxuli 28-Jul-15 14:28pm

DropDownList ddl;
foreach (GridViewRow gvRow in gvProf.Rows)
{
ddl = (DropDownList)(gvRow.Cells[5].FindControl("ddlDcode"));
ddl.DataSource = ds;
ddl.DataTextField = ds.Tables[0].Columns["dis_name"].ToString();
ddl.DataValueField = ds.Tables[0].Columns["dis_code"].ToString();
ddl.DataBind();
}
It is working fine

Richard Deeming 28-Jul-15 14:35pm

Do you really think the OP is still waiting for your answer after nearly five years?!

lapislaxuli · Answer 3 · 2015-07-28T08:29:00

Solution 4

DropDownList ddl;
foreach (GridViewRow gvRow in gvProf.Rows)
{
ddl = (DropDownList)(gvRow.Cells[5].FindControl("ddlDcode"));
ddl.DataSource = ds;
ddl.DataTextField = ds.Tables[0].Columns["dis_name"].ToString();
ddl.DataValueField = ds.Tables[0].Columns["dis_code"].ToString();
ddl.DataBind();
}

Posted 28-Jul-15 8:29am

lapislaxuli

Comments

Richard Deeming 28-Jul-15 14:35pm

Do you really think the OP is still waiting for your answer after nearly five years?!

How to bind dataset values into itemtemplate dropdown control in gridview

3 solutions

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us