Update ASP.Net GridView record on RowUpdating event using C#

Hi smile,

I have modified your code. Refer the updated code.

HTML

<div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Class="table table-striped table-bordered table-hover"
        OnDataBound="OnDataBound" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">
        <Columns>
            <asp:TemplateField ItemStyle-Width="20">
                <HeaderTemplate>
                    <asp:CheckBox ID="checkAll" runat="server" />
                </HeaderTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="CheckBox1" runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:BoundField DataField="ClassName" HeaderText="Class" ItemStyle-Width="100" />
            <asp:BoundField DataField="SectionName" HeaderText="Section" ItemStyle-Width="100" />
            <asp:TemplateField HeaderText="Reg No.">
                <ItemTemplate>
                    <asp:Label ID="lblAdmissionNo" runat="server" Text='<%# Eval("AdmissionNo") %>'></asp:Label>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:HiddenField ID="hfAdmissionNo" Value='<%# Eval("AdmissionNo") %>' runat="server" />
                    <asp:Label ID="lbl_AdNo" runat="server" Text='<%# Eval("AdmissionNo") %>'></asp:Label>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:BoundField DataField="SName" HeaderText="Student Name" ItemStyle-Width="100" />
            <asp:BoundField DataField="FName" HeaderText="Father Name" ItemStyle-Width="100" />
            <asp:TemplateField HeaderText="Subject Code">
                <ItemTemplate>
                    <asp:Label ID="lblSubjectID" runat="server" Text='<%# Eval("SubjectID") %>' Width="75"></asp:Label>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:HiddenField ID="hfSubjectID" Value='<%# Eval("SubjectID") %>' runat="server" />
                    <asp:Label ID="Label3" runat="server" Text='<%# Eval("SubjectID") %>' Width="75"></asp:Label>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:BoundField DataField="SubjectName" HeaderText="Subject Name" ItemStyle-Width="100" />
            <asp:BoundField DataField="MaxMarks" HeaderText="Total Marks" ItemStyle-Width="100" />
            <asp:BoundField DataField="PassMarks" HeaderText="Pass Marks" ItemStyle-Width="100" />
            <asp:TemplateField HeaderText="Marks">
                <ItemTemplate>
                    <asp:Label ID="Label6" runat="server" Text='<%# Eval("Marks") %>'></asp:Label>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="txtMarks" runat="server" Text='<%# Eval("Marks") %>' Width="75"></asp:TextBox>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Edit" ShowHeader="false">
                <ItemTemplate>
                    <asp:LinkButton ID="btnedit" runat="server" CommandName="Edit" Text="Edit"></asp:LinkButton>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:LinkButton ID="btnupdate" runat="server" CommandName="Update" Text="Update"></asp:LinkButton>
                    <asp:LinkButton ID="btncancel" runat="server" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
                </EditItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
    <script type="text/javascript" src="quicksearch.js"></script>
    <script type="text/javascript">
        $(function () {
            $('.search_textbox').each(function (i) {
                $(this).quicksearch("[id*=GridView1] tr:not(:has(th))", {
                    'testQuery': function (query, txt, row) {
                        return $(row).children(":eq(" + i + ")").text().toLowerCase().indexOf(query[0].toLowerCase()) != -1;
                    }
                });
            });
        });
    </script>
</div>

C#

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
    GridView1.EditIndex = e.NewEditIndex;
    this.BindGrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    GridViewRow row = GridView1.Rows[e.RowIndex];
    HiddenField hf_AdNo = row.FindControl("hfAdmissionNo") as HiddenField;
    HiddenField hf_Sub = row.FindControl("hfSubjectID") as HiddenField;
    TextBox Marks = row.FindControl("txtMarks") as TextBox;
    con = new SqlDbConnect();
    con.SqlQuery("Update tblSetMarks set Marks=@Marks where SubjectID= @SubId and AdmissionNo=@AdNo");
    con.Cmd.Parameters.Add(new SqlParameter("@SubId", hf_Sub.Value));
    con.Cmd.Parameters.Add(new SqlParameter("@AdNo", hf_AdNo.Value));
    con.Cmd.Parameters.Add(new SqlParameter("@Marks", Marks.Text));
    con.NonQueryEx();
    GridView1.EditIndex = -1;
    this.BindGrid();
}
protected void OnDataBound(object sender, EventArgs e)
{
    GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
    for (int i = 0; i < GridView1.Columns.Count; i++)
    {
        TableHeaderCell cell = new TableHeaderCell();
        TextBox txtSearch = new TextBox();
        txtSearch.Attributes["placeholder"] = GridView1.Columns[i].HeaderText;
        txtSearch.CssClass = "search_textbox";
        cell.Controls.Add(txtSearch);
        row.Controls.Add(cell);
    }
    GridView1.HeaderRow.Parent.Controls.AddAt(0, row);
}