2

I have a dojo datagrid which cells I will like to change at will depending on changes in user choice. The store used for the grid is populated from multiple database tables. This particular feature is very central to the application I am working on as there are a lot of calculations which results affects other cells in the grid.

I figure it will be something like get the grid, get the row based on an index and then get the cell by name. However I have not been able to figure how to do this.

Napoleon
  • 879
  • 2
  • 14
  • 36

1 Answers1

8

To change the data displayed in a dojo datagrid, you need to update the grid's store instead. Suppose that you want to edit the cell of column 'Name' in the current selected row, first get the row's index:

var index = grid.selection.selectedIndex;

Then get the row:

var item = grid.getItem(index);

Update the cell:

var store = grid.store;
store.setValue(item, 'Name', 'Your value');

Finally, update the grid's display

grid.update();
Fu Cheng
  • 3,385
  • 1
  • 21
  • 24
  • 1
    if you get 'setValue is not a function' you're using ItemFileReadStore, you need to use ItemFileWriteStore if you're going to update any data. – Brendon-Van-Heyzen Mar 26 '12 at 22:01
  • How same can be done on [dgrid](https://github.com/SitePen/dgrid)? I want to change two different columns value on change of another column value in same row. – Justin John Mar 21 '14 at 10:23