<div>
Use a CurrencyManger to loop through all records next to the record you change and set previous order value + 1
</div>


Use a CurrencyManger to loop through all records next to the record you change and set previous order value + 1

<div>
<div class="content wysiwyg-content">
My users would like to reorder the records in a bound datagrid by using Up/Down buttons. &nbsp;The DG also manages additions/deletetions of records. &nbsp;I have tried adding a field in the table to hold the SortOrderValue. &nbsp;When moving a record up or down I can increase/decrease the SortOrderValue by 1 and rewrite the record to the database, but how do I change the SortOrderValue of the &quot;other&quot; record that is being reordered? &nbsp; I guess what I'm asking is after updating the SortOrderValue for the selected record, how do I determine which other record will be affected so I can correct its SortOrderValue.<br />
<br />
Thanks in advance,<br />
<br />
Scott
</div>
</div>


My users would like to reorder the records in a bound datagrid by using Up/Down buttons.  The DG also manages additions/deletetions of records.  I have tried adding a field in the table to hold the SortOrderValue.  When moving a record up or down I can increase/decrease the SortOrderValue by 1 and rewrite the record to the database, but how do I change the SortOrderValue of the "other" record that is being reordered?   I guess what I'm asking is after updating the SortOrderValue for the selected record, how do I determine which other record will be affected so I can correct its SortOrderValue.

Thanks in advance,

Scott

Changeing the order of records in a bound datagrid using Up/Down buttons

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,