Qfyilyi

Quite new to asp using vb. Want to edit row entries in grid view using row command and stored procedure. Pease find code below

Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs)Dim id As String = GridView1.DataKeys(e.RowIndex).Value.ToString()

    Dim deptName As TextBox = CType(GridView1.Rows(e.RowIndex).FindControl("Department_Name"), TextBox)

    Dim deptDesc As TextBox = CType(GridView1.Rows(e.RowIndex).FindControl("Department_Description"), TextBox)



    stored procedure here



    Response.Write("<script language=VBScript>MsgBox """ + success + """</script>")



    GridView1.EditIndex = -1

    GridView1.DataBind()

End Sub

aspx page

<asp:TemplateField HeaderText="Department Description">

                            <ItemTemplate>

                                <asp:Label ID="Label2" runat="server" Text='<%# Eval("Department_Description") %>'></asp:Label>

                            </ItemTemplate>



                            <EditItemTemplate>

                                <asp:TextBox ID="deptDesc" runat="server" Text='<%# Eval("Department_Description") %>'></asp:TextBox>

                            </EditItemTemplate>



                        </asp:TemplateField>



                    <asp:TemplateField HeaderText="Action">

                        <ItemTemplate>

                             <asp:LinkButton ID="btnEdit" CommandName="ToEdit" CommandArgument="<%# CType(Container,GridViewRow).RowIndex %>"

                            Text="Edit" runat="server" CssClass="btn btn-sm  btn-info " ToolTip="Click to edit" />

                             <asp:LinkButton ID="btnDelete" CommandName="ToDelete" CommandArgument="<%# CType(Container, GridViewRow).RowIndex %>"

                            Text="Delete" runat="server" CssClass="btn  btn-sm btn-danger" ToolTip="Click to Delete" />

                            <asp:LinkButton ID="btnUpdate" CommandName="ToUpdate" CommandArgument="<%# CType(Container, GridViewRow).RowIndex %>"

                            Text="Update" runat="server" CssClass="btn  btn-sm btn-success" ToolTip="Click to Update"/>

                        </ItemTemplate>