jQuery Grid Plugin - jqGrid

Hi,

I am using entity framework and create JSON within ASP.NET MVC. I am using this prototype code and it works:

 public JsonResult Data(string _search, string sord, string sidx)
{
    var result = new JsonResult();

    if( _search.Equals("true") == true ) // search - to be done
    {

    }
    else
    {
 List<test1> list;

 double count = _entities.test1.Count();
 double number_of_requested_rows = Convert.ToDouble( Request.QueryString["rows"] );
 double requested_page = Convert.ToDouble(Request.QueryString["page"]);
 double total_pages = 0;
 var page = new { page = requested_page.ToString() };

 if (count > 0)
 {
     total_pages = Math.Ceiling(count / number_of_requested_rows);
 }

 double start_index =  (number_of_requested_rows * requested_page) - number_of_requested_rows;

 if( start_index < 0 )
 {
     start_index = 0;
 }

 if (sord.Equals("desc") == true)
 {
     list = _entities.test1.OrderBy(sidx, true).Skip((int)start_index).Take((int)number_of_requested_rows).ToList();
 }
 else
 {
     list = _entities.test1.OrderBy(sidx, false).Skip((int)start_index).Take((int)number_of_requested_rows).ToList();
 }

 var rows = from t in list
    select
    new
    {
        id = t.pk,
        cell = new[]
        {
     t.pk.ToString(),
     t.col1,
     t.col2,
     t.col3
        }
    };

 object userdata = new{TYPE = "",MSG = "hello world"};

 result.Data = new { total = total_pages, page = requested_page, records = count, userdata = userdata, rows };
    }

    return result;
}

Perhaps this helps it maps this simple table

pk int,

col1 char,

col2 char,

col3 char

I am sure it can be improved.

 Christian