overview
some functions for using jqgrid
- Client: javacsript function for customer mutil-search
- 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
- support jqgrid
- Independent client JavaScript function(named DataService)
- support paging, sorting and complex search condition
- Client and Server side cache
How to use:
- Query parameter:
- qn: your table or view name for get data ,is mandatory
- idcol: Primary key of table or view, default value is 'id'
- 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
- Demo
- use demotable.sql restore database
- modify database connectioin string in configHelper.cs
- run
Reference
- Newtonsoft.Json.dll http://json.codeplex.com/
- jqGrid http://www.trirand.com/blog/
- Hashtable http://www.mojavelinux.com/articles/javascript_hashes.html
- jquery.json-2.3.min http://code.google.com/p/jquery-json/