Dropdowns inside the gridview are not populating values from Database

Question

0.00/5 (No votes)

See more:

Hi,

I have two dropdown inside the gridview
Like DDL1 and DDL2
On the change event of DDL1 second dropdown DDL2 is binding.
But my problem is when Ist time page is loading my both dropdowns are not populating value which are coming from database.
SEcond Dropdown DDL2 i can understand it would not bound but Ist Dropdown DDL1 should display value from database .
How should i do it?

Thanks

Posted 10-May-12 2:36am

ManiV1

Add a Solution

Comments

Sandeep Mewara 10-May-12 9:07am

It would be difficult for anyone to tell what could be going wrong without seeing your code related to it.

Herman<T>.Instance 11-May-12 7:08am

bind it in the onrowdatabound event of the gridview

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)

Meenakshi_V · Answer 1 · 2012-05-11T20:51:00

XML

try this ,first take a template field then add item template,then inside edit template put the dropdown as follow...

<asp:templatefield headertext="Status" sortexpression="with_status" xmlns:asp="#unknown">

<asp:label id="Label1" runat="server" text="<%# Bind("with_status") %>">



<asp:dropdownlist id="DropDownList1" runat="server">
<asp:listitem value="0">-Select-
<asp:listitem value="1">pending
<asp:listitem value="2">completed






aspx.cs

on rowupdating put the following code

DropDownList ddl2 = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DropDownList1");
if (ddl2.SelectedValue.ToString() != "0")
{
SqlDataSource1.UpdateParameters["with_status"].DefaultValue = ddl2.SelectedItem.ToString();

}