I Have problem in use jqGrid,Before discussing the question of explain tables.
i have 4 tables CostType,CurrencyUnit , Request,RequestCost .
CostType Table structure
CostId CostName
------- ----------
1 permit
2 Warehouse receipt
3 Warehousing
and Request structure
RequestId RequestNo WaybillNo
------------------------------------------
1 100 120Ac30
2 101 400CA852
and CurrencyUnit table stracture:
UnitId UnitName
------------------
1 Dollar
2 Pound
3 Rial
and CostRequest table stracture
requestId CostId Amount CurrencyUnitId Remark
--------------------------------------------------------
1 2 200 3
1 1 400 1
i want in fill page load grid As follows:
Afterwards user can enter request No in top textbox and click button search As follows: user can change or enter some Cost Amount for this request As follows: and click in save button to save in database. Notes: i'm starter in jqGrid i can fill first Grid other two-step i can not implemet. please help me . thanks all
It's a little difficult to answer on your question without writing the code for you.
The input field for "RequestNo" (having id="requestNo" for example) and the "Search" button could be simple controls in
<fieldset>
over the grid.click
handler of the "Search" button can just call$("#grid").trigger("reloadGrid", [{page:1}])
. Inside of grid definition you can usepostData
likeYou can add additionally "Save" button which would call
$("#grid").jqGrid("saveRow", editingRowId);
to save the last editing row ifeditingRowId
is notundefined
.It is important to add
editable: true
to all columns which you want to see in editing mode. If you want to have all editing columns in the grid you can usecmTemplate: {editable: true}
jqGrid option. It changes the defaults for column definitions defined incolModel
.To have dropdown in the "CurrencyUnit" column you should include additional properties in the column definition: