Code:

1     protected void Page_Load(object sender, EventArgs e)
2            {
3                if (!this.Page.IsPostBack)
4                {
5                    CountforPager();
6                }
7    
8            }
9    
10           protected void CountforPager()
11           {
12               Comments com = new Comments();
13               CommentsQuery comq = com.Query;
14               comq.Where(comq.Status == 2);
15               comq.es.CountAll = true;
16               comq.es.CountAllAlias = "Count";
17               if (comq.Load())
18               {
19                   EsDataSrc.TotalRowCount = (int)com.GetColumn("Count"); //count for the paging
20               }
21               GridViewCom.Sort(CommentsMetadata.PropertyNames.DateAdded, SortDirection.Ascending);
22           }
23   
24   
25           protected void EsDataSrc_esSelect(object sender, EntitySpaces.Web.esDataSourceSelectEventArgs e)
26           {
27               CommentsCollection comcoll = new CommentsCollection(); // create the source for the gridview
28               comcoll.Query.Where(comcoll.Query.Status == 2);
29               e.Collection = comcoll;
30           }
31   
32   
33   
34           protected void EsDataSrc_esDelete(object sender, EntitySpaces.Web.esDataSourceDeleteEventArgs e)
35           { //delete  
36               Comments com = new Comments();
37               if (com.LoadByPrimaryKey((int)e.PrimaryKeys[0]))
38               {
39                   com.MarkAsDeleted();
40                   com.Save();
41                   e.Entity.MarkAsDeleted();
42                   CountforPager(); //update the data after delete
43               }
44   
45           }
46   
47           protected void EsDataSrc_esUpdate(object sender, EntitySpaces.Web.esDataSourceUpdateEventArgs e)
48           { //approve - update
49               Comments com = new Comments();
50               if (com.LoadByPrimaryKey((int)e.PrimaryKeys[0]))
51               {
52                   com.Status = 1;
53                   com.Save();
54                   CountforPager(); //update the data after approve 
55               }
56           }
57           protected void GridViewCom_RowDeleting(object sender, GridViewDeleteEventArgs e)
58           {
59               int a = e.RowIndex;
60               GridViewCom.DeleteRow(a); 
61               CountforPager();
62           }
63   

Code:

protected void EsDataSource1_esCreateEntity(object sender, EntitySpaces.Web.esDataSourceCreateEntityEventArgs e)
{
	Employees entity = new Employees();

	if (e.PrimaryKeys != null)
	{
		entity.LoadByPrimaryKey((int)e.PrimaryKeys[0]);
	}

	// Assign the Entity
	e.Entity = entity;
}

Code:

<asp:CommandField ShowEditButton="True" ShowSelectButton="True" ShowDeleteButton="true" ButtonType="Button" InsertVisible="False" >

Code:

protected void EsDataSrc_esCreateEntity(object sender, EntitySpaces.Web.esDataSourceCreateEntityEventArgs e)
        { 
            //implement esCreateEntity
            Comments com = new Comments();

            if (e.PrimaryKeys != null)
                com.LoadByPrimaryKey((int)e.PrimaryKeys[0]);
            else
                com.AddNew();

            e.Entity = com;
        }

Code:

<cc1:esdatasource id="EsDataSource1" runat="server" 
    onescreateentity="EsDataSource1_esCreateEntity" 
    onesselect="EsDataSource1_esSelect" 
    AutoPaging="True" 
    AutoSorting="True"/>

I definitely works.

Code:

"GridViewCom"  runat="server" DataKeyNames="Id"......>