jqgrid in asp.net using json datatype

Question

hi i am jqgrid which is binded dynamically using json datatype.my problem is with pageing. I wrote the script for jqgrid in AddCategory.aspx and redirected this page to AddCategoryGrid.aspx where i wrote the code for binding jqGrid data. It is displaying all records in one page but not allowing the pagging.

The code in AddCategoryGrid.aspx public partial class AddCatogoryGrid : System.Web.UI.Page {

    string sidx;
    string sord;
    int page;
    int rows;
    DbProvider dbViewCat = new DbProvider();
    protected string connectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            sidx = Request.QueryString["sidx"];
            sord = Request.QueryString["sord"];
            page = Convert.ToInt32(Request.QueryString["page"]);
            rows = Convert.ToInt32(Request.QueryString["rows"]);        
            Response.Write(GetGridData(sidx, sord, page, rows));
            Response.End();

        }
    }

    public DataTable GetDataTable(string sidx, string sord, int page, int pageSize)
    {

        int startIndex = (page - 1) * pageSize;
        int endIndex = page * pageSize;
        DataTable dt = new DataTable();
        DataSet ds = dbViewCat.AdminSelectCat();
        dt = ds.Tables[0];
        return dt;
    }

    public int GetTotalCount()
    {
        DataSet count = dbViewCat.AdminSelectCount();
        int i = count.Tables[0].Rows.Count;
        return i;
    }
    public string GetGridData(string sidx, string sord, int page, int rows)
    {
        return JsonHelper.JsonForJqgrid(GetDataTable(sidx, sord, page, rows), rows, GetTotalCount(), page);
    }              
}

The script in AddCategory.aspx for JqGrid is

The Helper class i used is

public class JsonHelper
{
    public static string JsonForJqgrid(DataTable dt, int pageSize, int totalRecords, int page)
    {
        int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
        StringBuilder jsonBuilder = new StringBuilder();
        jsonBuilder.Append("{");
        jsonBuilder.Append("\"total\":" + totalPages + ",\"page\":" + page + ",\"records\":" + (totalRecords));
        bool First = true;
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            if (First)
            {
                jsonBuilder.Append(",\"rows\":[");
                First = false;
            }
            jsonBuilder.Append("{\"i\":" + (i) + ",\"cell\":[");
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                jsonBuilder.Append("\"");
                jsonBuilder.Append(dt.Rows[i][j].ToString());
                jsonBuilder.Append("\",");
            }
            jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
            jsonBuilder.Append("]},");
        }
        if (!First)
        {
            jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
            jsonBuilder.Append("]");
        }
        jsonBuilder.Append("}");
        return jsonBuilder.ToString();
    }     
}

Can anybody find why the pagging is not working properly.

jqgrid in asp.net using json datatype

Answers (1)

Related Questions