CODEWITHSUNDEEP
c#asp.netsql
gymcode
gymcode

Reputation: 4633

Update GridView with Dropdownlist control

I am using VS2005 C#.

Currently I have a GridView, and I have changed one of my GridView control to my column name Gender, from the default TextBox to a DropDownList, which I gave the ID of the control to GenderList, and it contains 2 values, M and F.

I have a default update statement which is able to update the GridView after edit, which is the following:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString=
"<%$ ConnectionStrings:SODConnectionString %>" UpdateCommand="UPDATE 
[UserMasterData] SET [Name] = @Name, [Age] = @Age, [ContactNo]=@ContactNo,
 [Address]=@Address, [Gender]=@Gender"/>

The above UPDATE query works perfectly, and now I have changed my Gender textbox to a dropdownlist, the UPDATE query gave me an error which says:

Must declare the scalar variable "@Gender".

I assume the UPDATE query couldn't find the value from my Gender column.

I tried to modify the UPDATE query to @GenderList, but it did not work as well.

Anyone knows what I should do do the UPDATE query so that my UPDATE query can find the value from my GenderList dropdownlist in my Gender column?

Thank you.

Below is my previous Gender column with a textbox control:

                <asp:BoundField  HeaderText="Gender" 
                DataField="Gender" 
                SortExpression="Gender"></asp:BoundField>

Below is my Gender with the dropdownlist control:

    <asp:TemplateField HeaderText="Gender" SortExpression="Gender" >
        <EditItemTemplate>
            <asp:DropDownList ID="GenderList" runat="server" Width="50px" >
                <asp:ListItem>M</asp:ListItem>
                <asp:ListItem>F</asp:ListItem>
            </asp:DropDownList>
        </EditItemTemplate>
        <ItemTemplate>

EDIT:

Tried implementing RowDatBound and onRowUpdating:

RowDatBound

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    DataRowView dRowView = (DataRowView)e.Row.DataItem;
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        if ((e.Row.RowState & DataControlRowState.Edit) > 0)
        {
            DropDownList genderList= (DropDownList)e.Row.FindControl("GenderList");
            genderList.SelectedValue = dRowView[2].ToString();
        }
    }
}

RowUpdating.aspx.cs

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{

DropDownList genderSelect =(DropDownList)GridView1.Rows[e.RowIndex].FindControl("GenderList");

SqlDataSource1.UpdateParameters["Gender"].DefaultValue = 
genderSelect.SelectedValue; --> error says not set to an instance of an object

}

Upvotes: 0

Views: 12908

Answers (2)

Pankaj Kumar
Pankaj Kumar

Reputation: 1768

If you are using SqlDataSource and updating data via it then all you have to do is to set 2 way binding for the dropdownlist GenderList.

You can set this via the designer or directly in source also

 <EditItemTemplate>
                <asp:DropDownList ID="GenderList" runat="server" 
                    SelectedValue='<%# Bind("Gender") %>'>
                    <asp:ListItem>M</asp:ListItem>
                    <asp:ListItem>F</asp:ListItem>
                </asp:DropDownList>
            </EditItemTemplate>

notice that here 2 way binding is being used.

Upvotes: 2

Ravi Gadag
Ravi Gadag

Reputation: 15881

you need to use its selected value property, dropdown list is collection of values, but you are assigning a scalar value to your update statements. You have to check when its in update mode, you need to get selected item value of dropdown list and use that value as parameter for update statements.
Editing with Dropdownlist in gridview

to check its in edit mode or not use like this in RowDataBound Event

if ((e.Row.RowState & DataControlRowState.Edit) > 0)

Upvotes: 0

Related Questions