GridView examples using with Update Delete command in asp.net

GridView examples using with Update Delete command in asp.net

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.OleDb;

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

{

    protected voidPage_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            GridView1.AllowPaging = true;

            GridView1.PageSize = 4;

            showgrid();

        }

    }

    void showgrid()

    {

        ShopingCart obj = newShopingCart();

        DataSet ds = new DataSet();

        ds = obj.DataSetReturn("Select *from ProductTable");

        GridView1.DataSource = ds.Tables[0];

        GridView1.DataBind();

    }

    protected voidGridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

    {

        GridView1.PageIndex = e.NewPageIndex;

        showgrid();

    }

    protected voidGridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

    {

       TextBoxtxtName=(TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0];

       TextBox txtImage = (TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0];

       TextBox txtRemarks = (TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0];

       stringstrupdate = "update ProductTable set ProductName='" + txtName.Text + "',Remarks='"+ txtRemarks.Text + "' where ProductId="+ GridView1.Rows[e.RowIndex].Cells[0].Text;

       Response.Write(strupdate);

       ShopingCart obj = newShopingCart();

       int x = obj.ForQuery(strupdate);

       GridView1.EditIndex = -1;

       showgrid();

    }

    protected voidGridView1_RowEditing(object sender, GridViewEditEventArgs e)

    {

        GridView1.EditIndex = e.NewEditIndex;

        showgrid();

  

    }

    protected voidGridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

    {

        GridView1.EditIndex = -1;

        showgrid();

    }

    protected voidGridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

    {

        string strdel = "delete from SaveToCarttTable where ID=" + GridView1.Rows[e.RowIndex].Cells[0].Text;

        Response.Write(strdel+"<script> alert('Row Deleted')</script>");

        ShopingCart obj = newShopingCart();

        int x = obj.ForQuery(strdel);

        showgrid();

    }

}