some functions for using jqgrid

  1. Client:    javacsript function for customer mutil-search
  2. Server:  C# function for parse querystring and build sql query command

Base on this project, when use JqGrid, what you should to do is just make a view in database and modify querystring in html.

Feature summary

  1. support jqgrid
  2. Independent client JavaScript function(named DataService) 
    1. support paging, sorting and complex search condition
    2. Client and Server side cache

How to use:

  1. Query parameter:
    1. qn: your table or view name for get data ,is mandatory
    2. idcol: Primary key of table or view, default value is 'id'
    3. coli: how many columns will be retrive from table or view ,if not set will retrive all column from view.
      some time,your view have many columns,but only few columns should be show in jqgrid
  2. Demo
    1. use demotable.sql restore database
    2. modify database connectioin string in configHelper.cs
    3. run


  1.  Newtonsoft.Json.dll  http://json.codeplex.com/
  2. jqGrid     http://www.trirand.com/blog/
  3. Hashtable    http://www.mojavelinux.com/articles/javascript_hashes.html
  4.  jquery.json-2.3.min  http://code.google.com/p/jquery-json/

Last edited Jul 27, 2012 at 1:51 AM by maskx, version 8