About Me

My photo
"Enoughtheory.com" had its humble beginning in the year 2011 by ( Founder of Enoughtheory.com ) Mr Ravi Kant Soni , an Enterprise Java and Spring Framework Specialist, with a bachelor degree (B.E) in Information Science and Engineering from Reva Institute of Technology at Bangalore. He has been into the software development discipline for many years now. Ravi has worn many hats throughout his tenure, ranging from software development, designing multi-tenant applications, integration of new technology into an existing system, to his current love of writing a Spring Framework book. Currently, he is a lead engineer at HCL Technology. Ravi has focused on Web and Enterprise development using Spring Framework for most of his career and has been extensively involved in application design and implementation. He has developed applications for Core-Bank, HR and Payroll System, and e-Commerce systems using Spring Framework. Ravi Kant Soni is author of book "Learning Spring Application development" http://learningspringapplicationdevelopment.com

Sunday 22 April 2012

jqGRID

http://www.scribd.com/doc/50888257/Tutorial-jqGrid 

Table of Contents
jqGrid ......................................................................................................................................... 4

How it Works .......................................................................................................................... 23

Tutorial: Creating Your First Grid .................................................................................................. 25

The Data................................................................................................................................ 25

The HTML .............................................................................................................................. 25

The Server-side File ................................................................................................................ 28

PHP and MySQL ...................................................................................................................... 29

COOP Example ....................................................................................................................... 31

Retrieving Data .......................................................................................................................... 33

XML Data ............................................................................................................................... 33

JSON Data ............................................................................................................................. 38

Array Data ............................................................................................................................. 43

Function ................................................................................................................................ 45

User Data .............................................................................................................................. 46

Basic Grids ................................................................................................................................ 48

Properties .............................................................................................................................. 49

Importing/Exporting Grid Configuration ..................................................................................... 56

Events ................................................................................................................................... 58

Methods................................................................................................................................. 59

Integrations ........................................................................................................................... 65

Navigating ................................................................................................................................. 67

Properties, Events and Methods ................................................................................................ 68

Custom Buttons ...................................................................................................................... 69

Searching .................................................................................................................................. 71

Searching on a Single Field ...................................................................................................... 71

Searching on Many Fields ......................................................................................................... 73

Editing ...................................................................................................................................... 76

Cell Editing............................................................................................................................. 76

Inline Editing .......................................................................................................................... 78

Methods................................................................................................................................. 81

Form Editing........................................................................................................................... 84

Advanced Grids .......................................................................................................................... 92

Multiselect Grids ..................................................................................................................... 92

Subgrids ................................................................................................................................ 94

Master/Detail Grids ............................................................................................................... 100

Treegrids ............................................................................................................................. 102

 
3 -User Modules ........................................................................................................................... 113

Posting Data......................................................................................................................... 113

Formatter ............................................................................................................................ 114

Show/Hide Columns .............................................................................................................. 117

Table to jqGrid ..................................................................................................................... 118

Case Applications ..................................................................................................................... 119

Images in Grids .................................................................................................................... 119

Dynamic Editing Forms .......................................................................................................... 120

Search Forms ....................................................................................................................... 123

Trouble-Shooting ..................................................................................................................... 127



==================================================================


How it Works
Understanding this will help you to work better with jqGrid and use the full capabilities of the plugin.The first thing we must understand is that we have two major divisions:
$

Server-side manipulation, and
$

Client-side representation.In other words, jqGrid is a component that helps you, in an easy way, to represent database informationon the client side using a server-side technology. Moreover it helps you to manipulate that data back intothe database.What is server-side manipulation (SSM)? There are many definitions possible, but I try to explain it interms of jqGrid.

Basically SSM means the server handles the editing and not the user's browser. SSM isn’t something that
is visible within a web page. Everything is done on the server side using any common programming
language. Basically it’s a server
-side command that tells the server to place a file or text within the pageonce it is called from a user.In terms of jqGrid this means that you should care about this: you must have a piece of code that dealswith information stored in the database using some scripting language and web server. Using this codeyou should be able to return requested information back to the client (web browser). jqGrid uses Ajaxcalls to retrieve the requested information and represent it to client using Java Script language.Having the needed (requested) information, jqGrid constructs the representation (tabular data)described by you in what is called the Column Model(colModel). The constructed tabular data at the client side has:
$

Caption layer
$

Header layer
$

Body layer
$

Navigation layer
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)