Newbie: Arbitrary list order in SQL?

[Guest]

Hello all,

I have an ASP.net page that uses an "aspataGrid" tag that is populated by
a System.Data.DataSet object. Data is sorted via a "sort_value" field in the
SQL table.

Until now, this page has just been for the display of data. Data entry is
handled via a separate system.

Now, I need to add the ability to change the order of the data records from
this screen. (Via changing the underlying "sort_value" field...)

What is the best way to do this in VB.net?

The UI needs to implement a "move up", "move down", "move first", and "move
last" button/link next to each data row on the paged display.

Any ideas?

Thanks for the help,

David

 

[Guest]

Anybody?

 

[Mike Ryan]

David,

This sounds like a job for Datagrid Girl:

http://www.datagridgirl.com/articles.aspx

You might find some of the sorting-related articles there helpful.

- Mike

 

[Guest]

Thanks for the link.

There is a lot of information there... I am not sure where to start... Can
you recommend a specific article?

-- David