GridView Update Not Firing

[spamguy]

I am working porting ugly .NET 1.1 DataGrids to 2.0 GridViews. The GridView fills correctly via SqlDataSource. When I click Edit -> [make a field change] -> Update, the page refreshes but the update command clearly never fired. (Putting stuff in the GridView's OnRowUpdating function proves this.) The row also remains in edit mode.

The code:

<asp:SqlDataSource ID="dsMyReports" runat="server" 
                ConnectionString="<%$ ConnectionStrings:vortex2devConnectionString %>"
                SelectCommand="SELECT [ID], [Name], [Description] FROM [Report] WHERE (([IsPublic] = @IsPublic) AND ([OwnedByUserID] = @userID))" 
                OnSelecting="dsMyReports_Selecting" 
                DeleteCommand="DELETE FROM Report WHERE ID = @reportID" 
                UpdateCommand="UPDATE Report SET Name = @Name, Description = @Description WHERE ID = @ID">
        <SelectParameters>
            <asp:Parameter DefaultValue="0" Name="IsPublic" Type="Int32" />
            <asp:Parameter DefaultValue="" Name="userID" Type="Int32" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="reportID" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="Name" />
            <asp:Parameter Name="Description" />
            <asp:Parameter Name="ID" />
        </UpdateParameters>
    </asp:SqlDataSource>
 
    <asp:GridView ID="myReportsGrid" runat="server" AutoGenerateColumns="False" DataSourceID="dsMyReports" DataKeyNames="ID">
        <Columns>
            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
            <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
            <asp:CommandField ControlStyle-Width="16px" ButtonType="Image" EditImageUrl="~/images/edit_icon2.gif" ShowEditButton="true" />
        </Columns>
    </asp:GridView>

Thanks!

[bhupinder]

We can update easily using sqldatasource
but you have to pass parameters same name of the column

like langid=@langid if we change,
langid=@id it will not work its better you must use rowediting event rather than
sqldatasource

 <asp:GridView ID="gvdata" runat="server" AutoGenerateColumns="False" DataKeyNames="locationID"
        DataSourceID="SqlDataSource1">
        <Columns>
            <asp:CommandField ShowEditButton="True" />
            <asp:BoundField DataField="locationID" HeaderText="locationID" InsertVisible="False"
                ReadOnly="True" SortExpression="locationID" />
            <asp:BoundField DataField="locationName" HeaderText="locationName" SortExpression="locationName" />
            <asp:BoundField DataField="langID" HeaderText="langID" SortExpression="langID" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MWCConnectionString %>"
        SelectCommand="SELECT [locationID], [locationName], [langID] FROM [tbl_locationInfo]"
        UpdateCommand="update tbl_locationinfo set locationName=@locationName ,langID=@langID where locationid=@locationid">
        <UpdateParameters>
            <asp:Parameter Name="locationName" />
            <asp:Parameter Name="langID" />
            <asp:Parameter Name="locationid" />
        </UpdateParameters>
    </asp:SqlDataSource>