enable paging to a custom membership gridview

[JustRun]

Hi,

This is the first time to work with ASP.NET.
I had a customized membership gridview, the problem is i can't enable paging feature or sorting.


1 protected DataSet MyGetAllUsers()
2 {
3 DataSet ds = new DataSet();
4
5 dt = ds.Tables.Add(" Users");
6 muc = Membership.GetA llUsers();
7
8 dt.Columns.Add( "UserName", Type.GetType("S ystem.String")) ;
9 dt.Columns.Add( "Email", Type.GetType("S ystem.String")) ;
10 dt.Columns.Add( "CreationDa te", Type.GetType("S ystem.DateTime" ));
11 dt.Columns.Add( "IsOnline", Type.GetType("S ystem.Boolean") );
12 dt.Columns.Add( "IsLockedOu t", Type.GetType("S ystem.Boolean") );
13
14 foreach (MembershipUser mu in muc)
15 {
16 DataRow dr;
17 dr = dt.NewRow();
18 dr["UserName"] = mu.UserName;
19 dr["Email"] = mu.Email;
20 dr["CreationDa te"] = mu.CreationDate ;
21 dr["IsOnline"] = mu.IsOnline;
22 dr["IsLockedOu t"] = mu.IsLockedOut;
23
24 dt.Rows.Add(dr) ;
25 }
26 return ds;
27 }
28
29 protected void btnShowAll_Clic k(object sender, System.EventArg s e)
30 {
31 grdUsers.Visibl e = true;
32 MyGetAllUsers() ;
33 grdUsers.DataSo urce = dt;
34 grdUsers.DataBi nd();
35 }

This code is working so good, I've tried to put the following code to enable paging and sorting, it didn't fire any error But also it didn't give me any result:

private string ConvertSortDire ctionToSql(Sort Direction sortDireciton)
{
string newSortDirectio n = String.Empty;

switch (sortDireciton)
{
case SortDirection.A scending:
newSortDirectio n = "ASC";
break;

case SortDirection.D escending:
newSortDirectio n = "DESC";
break;
}

return newSortDirectio n;
}

protected void grdUsers_PageIn dexChanging(obj ect sender, GridViewPageEve ntArgs e)
{
grdUsers.PageIn dex = e.NewPageIndex;
grdUsers.DataBi nd();
}

protected void grdUsers_Sortin g(object sender, GridViewSortEve ntArgs e)
{
DataTable dataTable = grdUsers.DataSo urce as DataTable;

if (dataTable != null)
{
DataView dataView = new DataView(dataTa ble);
dataView.Sort = e.SortExpressio n + " " + ConvertSortDire ctionToSql(e.So rtDirection);

grdUsers.DataSo urce = dataView;
grdUsers.DataBi nd();
}
}



Any ideas?