How to use GRID for mass input

Suite and Optimus Suite 5
#1

Hi all,

I want to achieve the following functionality thru grid can anybody guide me on that

  • I want to use grid for mass(batch) input into database like
  • Grid must be initilized with 1 row and 4 columns with each cell as textfield/dropdown.
  • That row will be empty row for data input
  • where user enters the date into the each cell of that row
  • here user may add one more row using add button,then add one more record details in that row
  • hit the save button
  • When he its a save button all rows data must go and save at the server side.

Thanks and Regards
Tirupathi Rao.P

#2

I want to use grid for mass(batch) input into database like
You can edit cells in grid and save changes in database. You can use 2 modes:

Grid must be initilized with 1 row and 4 columns with each cell as textfield/dropdown.
To create grid with for columns you may use:
grid.setHeader(“1,2,3,4”);
To add row in grid you may use:
grid.addRow(row_id,"");
To set column types you may use:
grid.grid.setColTypes(“txt,co,txt,co”);
Al available column \cell type is listed here docs.dhtmlx.com/doku.php?id=dhtm … cell_types

That row will be empty row for data input
To add empty row to the grid you may use:
grid.addRow(row_id,"");

where user enters the date into the each cell of that row
To make grid cell editable, you can use “ed” or “txt” types

here user may add one more row using add button,then add one more record details in that row
To add row in grid you can use addRow() method
docs.dhtmlx.com/doku.php?id=dhtm … ect_addrow

When he its a save button all rows data must go and save at the server side.
To simlify server side operation related DHTMLX components, you can try to use dhtmlxConnector extension. Please find more information here dhtmlx.com/docs/products/dhtmlxC … x.shtml?mn