Re: DataGridView Sorting Problem - C# Discussion Boards

AhmedOsamaMoh28-Dec-10 7:55

AhmedOsamaMoh

28-Dec-10 7:55

any easier solution ??

Not Active28-Dec-10 8:00

28-Dec-10 8:00

Yes, wait for .NET Framework 5.0 and hope they have implemented your specific sorting requirements into the DataGridView control.

I know the language. I've read a book. - _Madmatt

Keith Barrow28-Dec-10 9:22

Keith Barrow

28-Dec-10 9:22

Daoist Coding and Sarcasm, I like it!

Sort of a cross between Lawrence of Arabia and Dilbert.[^]
-Or-
A Dead ringer for Kate Winslett[^]

Not Active28-Dec-10 9:49

28-Dec-10 9:49

Sarcasm?

I know the language. I've read a book. - _Madmatt

Richard Andrew x6428-Dec-10 8:19

Richard Andrew x64

28-Dec-10 8:19

If you're able to control the format of the data, you can achieve what you want by padding the small numbers with leading zeros:

PC001
PC002
PC010
PC100

The difficult we do right away...
...the impossible takes slightly longer.

Not Active28-Dec-10 8:54

28-Dec-10 8:54

And what if the data needs to be displayed as is without leading zeros?

I know the language. I've read a book. - _Madmatt

Dave Kreskowiak28-Dec-10 9:26

Dave Kreskowiak

28-Dec-10 9:26

You can have a seperate column in the datatable that contains a normalized version of the display data. This normalized version could be used for sorting.

Then, when you bind the grid to the table, you simply don't include this sort column in the bindings.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Not Active28-Dec-10 9:30

28-Dec-10 9:30

Yes, of course. I was trying to point out to the OP is isn't as simple as just changing the data in the column.

I know the language. I've read a book. - _Madmatt

Dave Kreskowiak28-Dec-10 11:16

Dave Kreskowiak

28-Dec-10 11:16

Yeah, some people just don't want to write code to solve problems anymore. They think that the .NET Framework can read minds and do everything you intended with just a few statements.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Richard Andrew x6428-Dec-10 10:02

Richard Andrew x64

28-Dec-10 10:02

He asked for an easier solution and I suggested one.

It's up to him to decide whether it works for his particular case. He didn't introduce that additional requirement, you did.

The difficult we do right away...
...the impossible takes slightly longer.

Not Active28-Dec-10 10:14

28-Dec-10 10:14

An "easy" solution that ignores potential pitfalls is not good advice, but, yes, it is up to the OP.

I know the language. I've read a book. - _Madmatt

GenJerDan28-Dec-10 8:20

GenJerDan

28-Dec-10 8:20

Normalize the numbers?

Read the table from a view instead of directly and have a new computed column containing the data as PC001, PC002, PC010, PC100, etc.

Sort on that, but don't show it.

Not Active28-Dec-10 8:52

28-Dec-10 8:52

So now you need to create a process in SQL Server to create the column and format the strings so they can be sorted. Roll eyes | :rolleyes:

What happens when there are more than three digits? What happens when the business logic changes or the field changes?

I know the language. I've read a book. - _Madmatt

GenJerDan28-Dec-10 9:00

GenJerDan

28-Dec-10 9:00

Mark Nischalke wrote:
What happens when there are more than three digits?

Um...you take 15 seconds to increase the size in function? Or set it to left-pad with zeros out to 20* places from the get-go and not worry about it? (* or whatever is reasonable)

Mark Nischalke wrote:
What happens when the business logic changes or the field changes?

Well, that changes more than this little bit, so why worry about it since a boatload of stuff will need to be rewritten, anyway?

And, if that happened, you'd be rewriting any custom sorting in the program itself if you made your own comparer there. Me, I'd rather avoid that and just change a view.

Not Active28-Dec-10 9:17

28-Dec-10 9:17

GenJerDan wrote:
you'd be rewriting any custom sorting in the program itself if you made your own comparer there.

Not quite. Had similar requirements and wrote the comparer well enough the first time, no need to keep updating it.

I know the language. I've read a book. - _Madmatt

AhmedOsamaMoh29-Dec-10 5:27

AhmedOsamaMoh

29-Dec-10 5:27

well thx all

well i guess the easiest way OMG | :OMG:

that i will recode my code by using the datagridview without the databinding so i can use
SortCompare(object sender, DataGridViewSortCompareEventArgs e)

thanks anyway all

and thanks also to whom comment on my Q in a funny way Confused | :confused:

bye

tim_gunning4-Jan-11 4:38

tim_gunning

4-Jan-11 4:38

bing bong[^]

TimeStamp server (TSA)

abbd28-Dec-10 7:38

28-Dec-10 7:38

Hello,

I search a free TSA server, there are one ?

Thank you verry mutch.

Not Active28-Dec-10 7:41

28-Dec-10 7:41

Have you looked here[^] Poke tongue | ;-P

I know the language. I've read a book. - _Madmatt

abbd28-Dec-10 7:53

28-Dec-10 7:53

Hello,

it isn't the time stamp server Smile | :)

Thank you.

Ravi Bhavnani28-Dec-10 9:46

Ravi Bhavnani

28-Dec-10 9:46

Here[^] you go.

/ravi

My new year resolution: 2048 x 1536
Home | Articles | My .NET bits | Freeware

ravib(at)ravib(dot)com

abbd28-Dec-10 10:50

28-Dec-10 10:50

Hello,

I need the url of TSA, login for TSA et finnaly password TSA.

Thank you verry mutch.

Ravi Bhavnani28-Dec-10 10:57

Ravi Bhavnani

28-Dec-10 10:57

What do you mean by "TSA"? If it's time servers you're looking for, the link I sent you should meet your needs. There are no logins or passwords involved.

/ravi

My new year resolution: 2048 x 1536
Home | Articles | My .NET bits | Freeware

ravib(at)ravib(dot)com

abbd28-Dec-10 11:02

28-Dec-10 11:02

Hello,

I need a time stamp server for sign my dcuments. there are a free time stamp server?

Thank you verrry mutch.