sending edited column value to datatable

[gourinaik98]

Hello,

I currently have a datatable with one of the columns as scheduleno. This is editable. Now i want to send the column value edited during runtime to my datatable. kindly let me know how we can achieve this.

Also, which widget is btter for this functionality, gird or adv-grid? if we use adv-grid, pls share step by step procedure to do the same.

Thank you

[PaiChung]

The regular Grid can only provide the full edited table, so not just the column.

The advanced Grid I believe can provide in addition to edited table, it can provide changed rows, again not just the column.

So based on that you need to run some logic that compares values and does updates based on that.

[gourinaik98]

Can u please give me an example with respect to retrieving changed row
values?
So you are saying that I have to take changed row values as input to a
service, loop through the input and send the output to
AddorUpdateDataEntries service of my data table?

[PaiChung · Accepted solution]

Correct, the Grid widget will have a 'Property' called 'Edited Table' which is the table you can use as an input to the service. the Advanced Grid should feature an additional property called 'Changed Row(s)'

And then indeed you would loop through it and use AddorUpdate service

[gourinaik98]

Thank you, but I could not find any property called Changed Rows in the advanced grid

[PaiChung]

It looks like it doesn't have that, sorry, it has EditedTable, it has selectedrows (not the same)

so you'll have  too use EditedTable