Hi. I posted this in the mailing list, but the reply I got wasn't too clear, so maybe I'll have better luck here.
I currently have a grid with data in it. I would like to know if there is a way to give each generated row an ID, or at least, associate each row with an object.
It may make it more clear if I clarify what i'm doing. It is described below.
I pull data from an SQL table and display them in the grid. I am allowing for the user to add/delete rows and edit cells.
Say the user is viewing a grid that has 3 rows(which is, in turn, a mysql table with 3 rows). If he is on the last row and presses the down arrow key, a new row is created and he can enter data into it and it will be inserted in the database when he presses enter.
However, I need a way to find out which rows will use "insert" query and which will use "update" query.
So ideally, when the user creates a new row by pressing the down arrow, I would give that row an ID and store it in a list(or, if rows already have IDs, just store it in a list) and when the user finishes entering data in the cells and presses enter, I would check if that row's ID is in the in the list. If it is, i would insert all of that row's cells values into the table, if not, i would update mysql with the values.
Hope I made this clear.