Edit update delete in gridview in asp.net in template

Edit Update Delete in gridview in asp.net in template  :

Drop a GridView Control from the toolbox and set AutoGenerateColumns to false.

Add the Columns Collection (tag) that manages the collection of column fields.

Add Template Field inside the Columns Collection that is used to display custom content in a data-bound control.

Add an Item Template in the Template Field that specifies the content to display for the items in a Template Field.

Add an EditItem Template in the Template Field that specifies a custom user interface (UI) for the item in edit mode.

Set the Command name property to Edit in the Edit button, Update in the Update button and Cancel in the Cancel Button depending on their respective Events.

Add 

• OnRowEditing, 

• OnRowUpdating and 

• OnRowCancelingEdit 

events to the GridView.

Example of edit Update in gridview in asp.net:

<form id="form1" runat="server"> 

    <div>     

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="6" OnRowCancelingEdit="GridView1_RowCancelingEdit"  

 

OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating"> 

            <Columns> 

                <asp:TemplateField> 

                    <ItemTemplate> 

                        <asp:Button ID="btn_Edit" runat="server" Text="Edit" CommandName="Edit" /> 

                    </ItemTemplate> 

                    <EditItemTemplate> 

                        <asp:Button ID="btn_Update" runat="server" Text="Update" CommandName="Update"/> 

                        <asp:Button ID="btn_Cancel" runat="server" Text="Cancel" CommandName="Cancel"/> 

                    </EditItemTemplate> 

                </asp:TemplateField> 

                <asp:TemplateField HeaderText="ID"> 

                    <ItemTemplate> 

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

                    </ItemTemplate> 

                </asp:TemplateField> 

                <asp:TemplateField HeaderText="Name"> 

                    <ItemTemplate> 

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

                    </ItemTemplate> 

                    <EditItemTemplate> 

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

                    </EditItemTemplate> 

                </asp:TemplateField> 

                <asp:TemplateField HeaderText="City"> 

                    <ItemTemplate> 

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

                    </ItemTemplate> 

                    <EditItemTemplate> 

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

                    </EditItemTemplate> 

                </asp:TemplateField> 

            </Columns> 

            <HeaderStyle BackColor="#663300" ForeColor="#ffffff"/> 

            <RowStyle BackColor="#e7ceb6"/> 

        </asp:GridView> 

     

    </div> 

</form> 

In asp.net with C# how to do Update edit Delete in gridview in asp.net:

using System; 

using System.Data; 

using System.Data.SqlClient; 

using System.Configuration; 

using System.Web.UI.WebControls; 

 

public partial class _Default : System.Web.UI.Page 

{ 

    //Connection String from web.config File 

    string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; 

    SqlConnection con; 

    SqlDataAdapter adapt; 

    DataTable dt; 

    protected void Page_Load(object sender, EventArgs e) 

    { 

        if(!IsPostBack) 

        { 

            ShowData(); 

        } 

    } 

    //ShowData method for Displaying Data in Gridview 

    protected void ShowData() 

    { 

        dt = new DataTable(); 

        con = new SqlConnection(cs); 

        con.Open(); 

        adapt = new SqlDataAdapter("Select ID,Name,City from tbl_Employee",con); 

        adapt.Fill(dt); 

        if(dt.Rows.Count>0) 

        { 

            GridView1.DataSource = dt; 

            GridView1.DataBind(); 

        } 

        con.Close(); 

    } 

 

    protected void GridView1_RowEditing(object sender, System.Web.UI.WebControls.GridViewEditEventArgs e) 

    { 

        //NewEditIndex property used to determine the index of the row being edited. 

        GridView1.EditIndex = e.NewEditIndex; 

        ShowData(); 

    } 

    protected void GridView1_RowUpdating(object sender, System.Web.UI.WebControls.GridViewUpdateEventArgs e) 

    { 

        //Finding the controls from Gridview for the row which is going to update 

        Label id=GridView1.Rows[e.RowIndex].FindControl("lbl_ID") as Label; 

        TextBox name = GridView1.Rows[e.RowIndex].FindControl("txt_Name") as TextBox; 

        TextBox city = GridView1.Rows[e.RowIndex].FindControl("txt_City") as TextBox; 

        con = new SqlConnection(cs); 

        con.Open(); 

        //updating the record 

        SqlCommand cmd = new SqlCommand("Update tbl_Employee set Name='"+name.Text+"',City='"+city.Text+"' where ID="+Convert.ToInt32(id.Text),con); 

        cmd.ExecuteNonQuery(); 

        con.Close(); 

        //Setting the EditIndex property to -1 to cancel the Edit mode in Gridview 

        GridView1.EditIndex = -1; 

        //Call ShowData method for displaying updated data 

        ShowData(); 

    } 

    protected void GridView1_RowCancelingEdit(object sender, System.Web.UI.WebControls.GridViewCancelEditEventArgs e) 

    { 

        //Setting the EditIndex property to -1 to cancel the Edit mode in Gridview 

        GridView1.EditIndex = -1; 

        ShowData(); 

    } 

}  

Here we give the list of Examples related to gridview:

• How to Bind Gridview Form database.
• Show gridview Row Details.
• Export Data from Gridview to Excel in Asp.net using C#:
• Export Gridview Data to Excel in ASP.NET with C#
• Export GridView data to txt file in Asp.net using C#
• Templatefield in gridview
• Introduction of Asp.net grid view Control.
• Example of Templatefield in gridview .
• Example of DropDownList inside GridView
• Check box in ASP.NET GridView
• Ckeck box list example using javascript in grid.
• Check box in ASP.NET GridView
• Show grid view row details in to tooltip.
•  How to Bind Gridview Form database.

Other Crystal Report related Post:

• Make Crystal Report.
• Crystal report Advantages
• Example of Crystal Report:

Examples related to gridview:

• Show gridview Row Details.
• Templatefield in gridview
• Introduction of Asp.net grid view Control.
• Example of Templatefield in gridview .
• Example of DropDownList inside GridView
• Check box in ASP.NET GridView
• Ckeck box list example using javascript in grid.
• Check box in ASP.NET GridView
• Show grid view row details in to tooltip.
• How to Bind Grid view Form database.
• Show gridview Row Details And Give Example.
• Example of Template field.
• How to Bind Grid view Form database.
• Template field in asp.net grid view.
• Example of DropDownList inside GridView control
• Introduction of Asp.net grid view Control.
• Example of C# for Bind Data to asp.net Textbox inside gridview control
• Bind Data to asp.net textbox control in inside of gridview Using C# Example