drop down list binding during row editing of grid view

Question

0.00/5 (No votes)

See more:

Hi,

I have a grid view in which there are different feilds and every field is a template field. On iten template I have labels and on edit item template there are drop dwn lists.
My prob is that gv is binding perfectly and on the click of edit button it is taking me to edit the grid view...
but the drop down lists are not populated... means say if i have a field active with Yes or no and label has its value as yes, I want when i click on the edit button ddl should also show the yes option populated automatically. Do i have to do this on row databound event for each drop dwn list ?

Posted 13-May-12 19:07pm

Taresh Uppal

Add a Solution

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)

Mohamed Mitwalli · Answer 1 · 2012-05-13T19:43:00

Hi ,
You have to set SelectedValue with your columns
Check this Example .

ASP.NET

<div>
           <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
        onrowdeleting="GridView1_RowDeleting">
        <Columns>
            <asp:BoundField DataField="dd" HeaderText="dd" SortExpression="dd" />
            <asp:TemplateField HeaderText="ddd" SortExpression="ddd">
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("ddd") %>'></asp:Label>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ddd") %>'></asp:TextBox>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="cate" SortExpression="cate">
                <EditItemTemplate>
                    <asp:DropDownList ID="DropDownList1" runat="server"
                        DataSourceID="SqlDataSource12" DataTextField="cate" DataValueField="id"
                        SelectedValue="<%# Bind('cate') %>">
                    </asp:DropDownList>
                    <asp:SqlDataSource ID="SqlDataSource12" runat="server"
                        ConnectionString="<%$ ConnectionStrings:testConnectionString %>"
                        SelectCommand="SELECT * FROM [cate]"></asp:SqlDataSource>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("cate") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:CommandField ShowEditButton="True" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:testConnectionString %>"
        SelectCommand="SELECT * FROM [View_1]"></asp:SqlDataSource>
           <br />
           <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button"
                   style="height: 26px" />
</div>

Best Regards
M.Mitwalli

vangapally Naveen Kumar · Answer 2 · 2012-05-13T19:56:00

in row databound event

VB

Dim dtPriceSource As New DataTable()
                    dtPriceSource = CType(Session("123"), DataTable)
                    Dim ddl As DropDownList
                    ddl = New DropDownList()
                   ddl = CType(e.Row.FindControl("ddl"), DropDownList)
                    Dim mypricesouce As String = ddl.Text
                    ddl.DataSource = dtPriceSource
                    ddl.DataBind()
                   ddl.Items.Insert(0, New ListItem(" ", 0))
                    If IsDBNull(Gridview1.DataKeys(e.Row.RowIndex).Values(0)) = True Then
                        ddl.SelectedValue = 0
                    Else
                       ddl.SelectedValue = Gridview1.DataKeys(e.Row.RowIndex).Values(0)
                    End If

Taresh Uppal · Answer 3 · 2012-05-13T19:55:00

here is my code which I am using during gv row editing to pupulate the ddl...

C#

protected void gvAllClients_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gvAllClients.EditIndex = e.NewEditIndex;
        gvall_Client_fill();
        DataTable dtResult = (DataTable)(Session["gvAll_Client_fill"]);

        string strDatatype = Convert.ToString(dtResult.Rows[0]["DataType"]);
        string strComb = Convert.ToString(dtResult.Rows[0]["Combination"]);
        string strActive = Convert.ToString(dtResult.Rows[0]["IsActive"]);
        GridViewRow row = gvAllClients.Rows[e.NewEditIndex];
        DropDownList ddlDataType = (DropDownList)(row.FindControl("ddlDataTypeAll"));
        if (strDatatype == "EXPORT")
        {
            ddlDataType.SelectedItem.Text = "EXPORT";
        }

drop down list binding during row editing of grid view

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0