Dropdown list not being binded in GridView

Question

0.00/5 (No votes)

See more:

Hello everyone,

I have gridview as follows:

XML

<asp:GridView ID="role_update" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="role_update_RowCancelingEdit"
                                OnRowEditing="role_update_RowEditing" OnRowUpdating="role_update_RowUpdating"
                                CssClass="GridView">
                                <Columns>
                                    <asp:TemplateField HeaderText="Name" HeaderStyle-HorizontalAlign="Center">
                                        <ItemTemplate>
                                            <asp:Label ID="lblname" runat="server" Text='<%# Bind("name") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Code" HeaderStyle-HorizontalAlign="Center">
                                        <ItemTemplate>
                                            <asp:Label ID="lblcode" runat="server" Text='<%# Bind("code") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:TemplateField>
                                    <asp:TemplateField HeaderText="Role" HeaderStyle-HorizontalAlign="Center">
                                        <ItemTemplate>
                                            <asp:Label ID="role_label" runat="server" Text='<%# Bind("role") %>'></asp:Label>
                                        </ItemTemplate>
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <ItemStyle HorizontalAlign="Center" />
                                        <EditItemTemplate>
                                            <asp:DropDownList runat="server" ID="role_list" DataTextField="rolename" DataValueField="role" >
                                            </asp:DropDownList>
                                        </EditItemTemplate>
                                    </asp:TemplateField>
                                    <asp:CommandField HeaderText="Action" ShowEditButton="True" ButtonType="Button">
                                        <ControlStyle CssClass="btn" />
                                        <ItemStyle HorizontalAlign="Center" />
                                    </asp:CommandField>
                                </Columns>
                            </asp:GridView>

I want such that,when i click on edit,the role column dropdown list should be binded at that time,so i tried that in row editing event as follows:

C#

protected void role_update_RowEditing(object sender, GridViewEditEventArgs e)
        {            
            role_update.EditIndex = e.NewEditIndex;
            GridViewRow row = role_update.Rows[e.NewEditIndex];
            DropDownList dl = (DropDownList)row.FindControl("role_list");
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString=      System.Configuration.ConfigurationManager.ConnectionStrings["xyz"].ConnectionString;
            conn.Open();
            SqlCommand cmd = new SqlCommand("select  DISTINCT role from table", conn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            dl.DataSource = ds;
            dl.DataBind();
            conn.Close();
            rolebind();
        }

The problem is,i am getting object reference error at the line highlighted above,it means i am getting null dropdown as role_list is not there in itemtemplate,its in edititemtemplate.

My question is how to bind dropdown at time of editing?

I googled alot but every example shows binding in rowdatabound event,thats useless for me(as per as i think).If not,then how to accomplish that?

Any help would be really appreciated.

Posted 3-Jun-13 21:09pm

Sejal Rabari

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)

Zafar Sultan · Accepted Answer · 2013-06-03T21:20:00

You are using wrong event to bind your gridview. Use RowDataBound event to bind. For example:

C#

protected void YourGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
Control dl = e.Row.FindControl("yourDropDownList");
if (dl != null)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString=      System.Configuration.ConfigurationManager.ConnectionStrings["xyz"].ConnectionString;
conn.Open();
SqlCommand cmd = new SqlCommand("select  DISTINCT role from table", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
dl.DataSource = ds;
dl.DataBind();
conn.Close();
rolebind();
}
}