How do I get dropdownlist in edit item template in gridview asp.net.i have tried adding dropdownlist in edit item template

Question

0.00/5 (No votes)

See more:

iam not able to populate the dropdownlist in edit item template with the data before data binding.because of this on databind() iam getting the error.

aspx code:

<asp:TemplateField HeaderText="City">
                       <ItemTemplate>
                           <asp:Label Text='<%# Eval("City") %>' runat="server" />
                       </ItemTemplate>
                       <EditItemTemplate>
                          <asp:TextBox ID="txtCity" Text='<%# Eval("City") %>' runat="server" />
                       </EditItemTemplate>
                       <FooterTemplate>
                           <asp:DropDownList ID="CityDropDownListFooter"  runat="server" onselectedindexchanged="cityDropDownList_SelectedIndexChanged" AutoPostBack="True"></asp:DropDownList>
                       </FooterTemplate>
                   </asp:TemplateField>

aspx.cs code:

if (dtbl.Rows.Count > 0)
{
organizationGridview.DataSource = dtbl;
organizationGridview.DataBind();
}

What I have tried:

aspx code:

<pre> <asp:TemplateField HeaderText="City">
                        <ItemTemplate>
                            <asp:Label Text='<%# Eval("City") %>' runat="server" />
                        </ItemTemplate>
                        <EditItemTemplate>
                           <asp:TextBox ID="txtCity" Text='<%# Eval("City") %>' runat="server" />
                        </EditItemTemplate>
                        <FooterTemplate>
                            <asp:DropDownList ID="CityDropDownListFooter"  runat="server" onselectedindexchanged="cityDropDownList_SelectedIndexChanged" AutoPostBack="True"></asp:DropDownList>
                        </FooterTemplate>
                    </asp:TemplateField>

aspx.cs code:

if (dtbl.Rows.Count > 0)
{
organizationGridview.DataSource = dtbl;
organizationGridview.DataBind();
}

how do i get the data in the edit item dropdownlist?

surprisingly, rowdatabound function is not triggered on databind() call.

protected void organizationGridview_RowDataBound(object sender, GridViewRowEventArgs e)
{
Control ctrl = e.Row.FindControl("CityDropDownList");
if(ctrl!=null)
{
DropDownList ddl = (DropDownList)ctrl;
string connectionString = System.Configuration.ConfigurationManager.
ConnectionStrings["mydatabase"].ConnectionString;

MySqlConnection mcon = new MySqlConnection(connectionString);
mcon.Open();
String cmdText = "select distinct City from Organization union all select 'other';";

MySqlCommand cmd = new MySqlCommand(cmdText, mcon);
MySqlDataAdapter mysqladapter = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
mysqladapter.Fill(ds);
ddl.DataTextField = ds.Tables[0].Columns["City"].ToString();
ddl.DataSource = ds.Tables[0];
ddl.DataBind();
mcon.Close();
}
}

Posted 7-Jan-20 5:49am

kkgj

Updated 7-Jan-20 6:21am

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)

Vincent Maverick Durano · Answer 1 · 2020-01-07T06:21:00

The RowDataBound event should work. You need to check the RowType first and then check for the RowState. For example:

C#

protected void organizationGridview_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        if ((e.Row.RowState & DataControlRowState.Edit) > 0)
        {
            DropDownList ddlCity = (DropDownList)e.Row.FindControl("CityDropDownListFooter");
            
            //Do something with ddlCity here   

        }
    }
}

Since your DropDownList resides within a FooterTemplate, then you need check the RowType to ensure that you are only manipulating the rows of type Footer. Please note that a GridView is composed of several row types such as Header, DataRow, EmptyDataRow, Footer, Pager and Separator. The next line in code above is the critical part of the code and that is to determine the Edit state.

Accessing the controls from within <edititemtemplate> is a bit tricky, especially if you are not really familiar with how the stuff works within a GridView. Equating the RowState to DataControlState.Edit isn't really accurate and you might get an exception when doing so. The RowState property is a bitwise combination. Therefore, the RowState could indicate that you are in the Edit state and the Alternate state. Hence, you cannot do a simple equality check when you are in Edit mode. Instead you must do something like this when accessing controls within EditItemTemplate.

C#

if ((e.Row.RowState & DataControlRowState.Edit) > 0)   
{  
     //do your stuff here  
}

We use the bitwise "&" operator to determine if the GridView is in Edit mode and check the result if its greater than zero. For details about the Bitwise operator see: Bitwise Operators in C#.[^]