gridview and dropdownlist

Question

0.00/5 (No votes)

See more:

Hi,

I have a gridview and this gridview is bind to two database tables(Using Join). all column are template field.Normally this gridview show data as i want, but i also want to edit and add records using edit item template and footer template.
Because in the database their is foreign -primary key relation between two tables.
so i have used dropdownlist in for edit and add new records(template) to select id to foreign key column for one table.
I tried to bind these to dropdownlist using Row_DataBound() Event of gridview but it through exception at run time that object is not set to reference.

So please suggest me the other ways to bind dropdownlist with data from table in the edit and footer template of gridview.

thanks ]

\\\\
Balwant

Posted 1-May-11 18:26pm

Balwant.mnd

Add a Solution

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)

LakshmiNarayana Nalluri · Accepted Answer · 2011-05-01T18:46:00

Solution 1

Do one thing add event of dropdownlist

XML

<asp:dropdownlist id="ddl1" runat="server" onload="dropdown1_load">

in codebehind

C#

protected void dropdown1_load(object sender,EventArgs e)
{
    SqlDataAdapter da = new SqlDataAdapter("select sno from student", cn);
    DataTable dt = new DataTable();
    da.Fill(dt);
    DropDownList ddl = (DropDownList)sender;
    ddl.DataSource = dt;
    ddl.DataTextField = "sno";
    ddl.DataValueField = "sno";
    ddl.DataBind();
}

Posted 1-May-11 18:46pm

LakshmiNarayana Nalluri

Updated 1-May-11 19:01pm

v3

Comments

Ankur^\m/ 2-May-11 1:02am

Surround code snippets with PRE tags (code block). It makes the code readable.

velmahesh 2-May-11 1:32am

Hi Balwant,

i think it will work..

Balwant.mnd 2-May-11 1:37am

no it is not working because dropdownlist does not found because it is in the gridview edit template.
i will also tried to find suitable solution for it

Balwant.mnd 2-May-11 2:00am

Thanks Now it is working!
thanks a lot
Balwant.