Reorder Items in sql database
Posted on 2008-10-02
Hi all, looking for some help on re-ordering. I have a parent with several siblings, the siblings are ordered by a display_order field. I need to be able to drop a NEW sibling in the middle and re-order the siblings accordingly... I am thinking about making the display_order field go by 10's or 100's, and drop a new one in the middle, but I really don't like this solution and it would eventually fill up anyway. I'm sure there is some GREAT code out there to help out with this, or at least some ideas on how to go about it. I am doing this in Visual Studio 2005 VB.net. They are adding the siblings in via a detailsview grid.