Grid View Control

-->Write a Function in Administrator.cs class file as follows

 public DataSet viewEmployees()
    {
        obj.ds = SqlHelper.ExecuteDataset(obj.con, CommandType.StoredProcedure, "[sp_allemployees]");
        return obj.ds;
    }
 -----------------------------------------------------------------
-->write a Fill() Method in addemployee.aspx as follows

public void fill()    {
        DataSet ds = obj.viewEmployees();
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
-----------------------------------------------------------------

PAGE INDEXING

1) Set Property of Gridview ----Allow Paging=true;

2) and write code in
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
fill();
}
------------------------------------------
ROW EDITING

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        fill();
    }
----------------------------------------
ROW CANCELING


 protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        fill();
    }

----------------------------------------
 ROW DELETING

 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        obj.deleteemployee(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
        fill();
    }

OR
 --------------------------------------
Row Updating

protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        TextBox empno = (TextBox)GridView2.Rows[e.RowIndex].FindControl("txtempno") as TextBox;
        TextBox ename = GridView2.Rows[e.RowIndex].FindControl("txtename") as TextBox;
        TextBox esal = (TextBox)GridView2.Rows[e.RowIndex].FindControl("txtesal") as TextBox;
        sc2.UpdateGrid(Convert.ToInt32(empno.Text), ename.Text, Convert.ToDecimal(esal.Text));
       
 GridView2.EditIndex = -1;
        fillgrid();
    }

-------------------------------------------
 REferences
http://devilswork.wordpress.com/2009/03/27/gridview-row-edit-delete-and-update/