Hi,
Thanks again for helping me resolve issues with the Drag and Drop project in the past.
The drag and drop rows works great and users are loving the app!
The app is like a queue and is refreshed every 1 min. It basically waits and updates items coming in from another system into the main items table that is displayed into the drag and drop GridView.
What I need to do is whenever a new row is added to the main list table, it needs to be added to the end no matter what the list position is. My data is constantly being updated via an SQL job every minute and new rows are added from another system to the main list table.
For example, if my main list items are 1-10 and a new row/item comes in, it should be added to the bottom of the list. I should then end up with items 1-11. Another example, If my list is 1-10 and a row is removed because it does not exist from the other system, let's say item #3 is no longer available, then when a new item comes in, it should go to the bottom and not replace #3 on the list. Basically, when the GridView refreshes, it should update and re-order all rows accordingly but preserving the current positions/preference.
For example, if my list is 1-10, and #3 is removed, now I have a list 1, 2, 4, 5, 6, 7, 8, 9, 10. I need all rows to move from #4 to #3 and #5 to #4 positions, etc...? This needs to happen w/o user interaction because the GridView is adding and removing items every min. Like i said this is a queue system. Users only move/re-order items by drag and drop if they need to but not all the time.
How can I do this via SQL query? Is this possible?
Thanks for your help!
Gus
