Grid Events

Grid Editing ,Deleting,Updating...

SOURCE

<asp:GridView ID="grdDemo2" runat="server" AutoGenerateColumns="False" CellPadding="4" EnableModelValidation="True" ForeColor="#333333" GridLines="None" OnPageIndexChanging="grdDemo_PageIndexChanging" OnRowCancelingEdit="grdDemo_RowCancelingEdit" OnRowEditing="grdDemo_RowEditing" OnRowUpdating="grdDemo_RowUpdating" Style="font-weight: 700">

<AlternatingRowStyle BackColor="#FFCC66" ForeColor="White" Font-Names="Arial" />

<Columns>

<asp:TemplateField HeaderText="ID">

<ItemTemplate>

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

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="NAME">

<ItemTemplate>

<%# Eval("Name") %>

</ItemTemplate>

<EditItemTemplate>

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

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="DOB">

<ItemTemplate>

<%# Eval("Date") %>

</ItemTemplate>

<EditItemTemplate>

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

</EditItemTemplate>

</asp:TemplateField>

<asp:CommandField HeaderText="EDIT" ShowEditButton="True" ShowHeader="True" />    //This is editing column

</Columns>

</asp:GridView>

NOTE:

<%# Eval("Id")%>  :   Id  is a variable in the class file "Utility" 

<%# Eval("Name")%> Name  is a variable in the class file "Utility" <%#Eval("Email")%>  Email  is a variable in the class file "Utility"

<%# Eval("DOB")%>   DOB  is a variable in the class file "Utility"

C# Code

1. Create an asp.net app
2. Add a webform "AddEmployee.aspx"
3. Add a class file "HelperCls.cs"

HelperCls.cs

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.SqlClient;

namespace Demo_Pjct

{

    public class HelperCls

    {

SqlConnection con = new SqlConnection("Data Source=10.18.184.133;Initial Catalog=ABC_Demo;User ID=niituser;Password=niituser");

        private string name;

        private Int32 id;

        private string date;

        public Int32 Id

        {

            get { return this.id; }

            set { this.id = value; }

        }

        public string Name

        {

            get { return this.name; }

            set { this.name = value; }

        }

        public string Date

        {

            get { return this.date; }

            set { this.date = value; }

        }

        public List<HelperCls> getAll(string str)

        {

            List<HelperCls> lst = new List<HelperCls>();

            HelperCls obj;

            try

            {

                con.Open();

                SqlCommand  cmd = new SqlCommand(str, con);

                SqlDataReader   reader = cmd.ExecuteReader();

                while (rder.Read())

                {

                    obj = new HelperCls();

                    obj.Id = Convert.ToInt32(rder["id"]);

                    obj.Name = Convert.ToString(rder["name"]);

                    obj.Date = Convert.ToString(rder["dob"]);

                    lst.Add(obj);

                }

            }

            catch (Exception)

            {

            }

            finally

            {

                con.Close();

                con.Dispose();

            }

            return lst;

        }

      public bool Update(string str)

        {

            bool status = false;

            try

            {

                con.Open();

                SqlCommand  cmd = new SqlCommand(str, con);

                Int32 c = cmd.ExecuteNonQuery();

                if (c == 1)

                {

                    status = true;

                }

            }

            catch (Exception)

            {

            }

            finally

            {

                con.Close();

                con.Dispose();

            }

            return true;

        }

    }

}

AddEmployee.aspx

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace Employee_Managment_System

{

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

    {

      

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                Fill_Grid();

               

            }

        public void Fill_Grid()

        {
            string str = "select * from tbl_employee";

            List<HelperCls> Emp_List = emp.getAll(str );

            if (Emp_List.Count > 0)

            {

                grdEmployee.DataSource = Emp_List;

                grdEmployee.DataBind();

            }

            else

            {

                empCount = 1;

            }

        }

protected void grdEmployee_PageIndexChanging(object sender, GridViewPageEventArgs e)

        {

            grdEmployee.PageIndex = e.NewPageIndex; 

            Fill_Grid();

        }

protected void grdEmployee_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

        {

            e.Cancel = true;

            grdEmployee.EditIndex = -1;

            Fill_Grid();

        }

protected void grdEmployee_RowUpdating(object sender, GridViewUpdateEventArgs e)

 {
   HelperCls helper= new HelperCls();

   Label lblId = (Label)grdDemo.Rows[e.RowIndex].FindControl("lblId");

  TextBox txtName =  (TextBox)grdDemo.Rows[e.RowIndex].FindControl("txtName");

  TextBox txtDOB =  (TextBox)grdDemo.Rows[e.RowIndex].FindControl("txtDob");

   Int32 id =Convert.ToInt32(lblId.Text);

   string name = txtName.Text;

   DateTime dt =Convert.ToDateTime (txtDOB.Text);

 string str ="update tbl_employee set name='"+name+"',dob='"+dt+"' where   id='"+id+"'";

            bool status = helper.Update(str);

            cmd = new SqlCommand(str, con);
            Int32 status = cmd.ExecuteNonQuery();

            if (status == 1)

            {

                Response.Write("<script>alert('Updated')</script>");

                grdDemo.EditIndex = -1;

                ShowDemoGrid();

            }

            else

            {

                Response.Write("<script>alert('Updation faild')</script>");

            }

        }

      }

   }