I need to give my users the option of reordering individual rows in a datagrid. They should be able to move one row up or down in the Datagrid with the change in positioning saved back to the database via an ID field.

I'm completely stumped on how to begin this. Does anyone have any suggestions or sample code? This project is using VB.NET.

Thanks in advance for any help!

OK. Here's a start. First I have an OrderID column in the database. When I post the datagrid I have a template column that puts images of up and down arrows in the column. The top selection does not have an up arros and the last row does not have a down arrow. I have functions OrderUp and OrderDown that reorder the OrderID's for the selected row and either adding or subtracting one to the OrderID and either subtracting or adding one to either the row above or row below depending on whether you're moving up or down.

There are other alternate ways of doing this depending on your exact requirements.