I have already given it. When the user is done with the grid, populate the sorter column from the order in the grid, pass the TVP, please see http://www.sommarskog.se/arrays-in-sql-2008.html for examples, although assuming that you already have a DataTable, it is very simple. Just pass the DataTable as the value, and the type for the parameter is SqlDbType.Structured. (All assuming that you are using .Net.)

The stored procedure is just a straight update from the DataTable - or a MERGE statement, if you also want to permit the user to add and delete rows.