How to sort the selected rows of a gridview?

Question

0.00/5 (No votes)

See more:

Hi, I have looked everywhere for this but have only found the method to sort whole rows. Maybe I'm wording my search incorrectly.

I am writing a project that reads from a db on a memory stick, allows sorting and then writed it back.
What I want to do is Highlight a few rows, then sort just the selected rows. I have a drop down list to select the 'sort by' column and a sort button.

I'm sure there must be examples of this out there somewhere so any pointers welcome.

Posted 20-May-11 1:45am

smorg123456

Add a Solution

Comments

Karwa_Vivek 20-May-11 7:52am

is this is in Windows Form or
Web application?

smorg123456 20-May-11 8:46am

This is a windows form but I also want to make a web version in the future.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2011-05-20T03:24:00

I don't you're going to find examples on this. The grids are written (justifiably so) to treat the entire set of records it is showing the same. You sort all or nothing.

You're not doing that. You're treating an artibtrary block of records differently than the rest. How are you going to handle sorting disconnected (non-adjacent) records? Once "sorted", how do they end up back in the list? Are they moved into a contiguous block? Is so, where? What happens to the records that have to move to make room? Do the sorted records go back into the original selected "slots" that were selected? ...

This sounds easy on the surface, but there's a lot you have to account for. I doubt you're going to find a single example of this on the web anywhere, using a DataGridView or DataGrid anyway.

You'd have to grab the records that are selected, put them into their own collection with a Sort method, then remove the records from the original datatable, put the sorted ones back in according to your business rules, then rebind the grid to the new arrangement.

BTW, databases do not care about record order and do not support putting the records back into the database in a specific order. Sort order is handled by the ORDER BY clause or a select. There is no such thing as record order in the physical table itself. This means you'd have to have a column in the table dedicated to maintaining sort order.