How to sort numbers and assign position to it

Question

1.00/5 (1 vote)

See more:

I want to assign grades to numbers in datagridview like this.
Column1. | Column 2
200. | Grade A
390. |. Grade B
321. |. Grade C
228. |. Grade D
235. |. Grade E

This is how I want my program to look like but I've already generated column1 from. But I don't know how to check the largest number and attach the grades to it respectively.

I don't know how to go about it so I have no codes so far

Posted 23-Jan-16 1:46am

Richmond Boateng

Add a Solution

Comments

OriginalGriff 23-Jan-16 7:57am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Sorry, but that doesn't make a lot of sense - there is no obvious relation between your Column1 and Column 2 - A is 200, B is 390, C is 321, and so on.
Use the "Improve question" widget to edit your question and provide better information.

Richmond Boateng 23-Jan-16 8:10am

What I meant was I've already displayed colum1 from the database. But I want know how to display the grades according to the largest and to the lowest number. Meaning the lowest number will get the "grade D".

OriginalGriff 23-Jan-16 8:24am

That isn't what your example is showing, and what happens if there are 6 results? 27? We don't know these things, and we have no idea what you have in your code to "play with"! :laugh:
So take a step back, and then try to type up your problem as if you were explaining it to your mother over the phone - that way what you tell us should include all the info we need to help you.

Richmond Boateng 23-Jan-16 8:28am

I would be glad you say you don't have any idea rather than saying "we". What has this issue got to do with my mum. Please try to be ethical. The fact that you don't have an idea doesn't mean no one is also having.
Anyway thanks for your comments

Richmond Boateng 23-Jan-16 8:31am

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.
Let's work to help developers, not make them feel stupid.

I hope you have read this?

[no name] 23-Jan-16 8:32am

Not nice from your side! You are the one looking for help....

OriginalGriff 23-Jan-16 8:42am

This has nothing to do with your mum - but when you talk to her about your job you don't assume that she can see your screen, or understand your "short cuts" to describe what you have been doing. We are in the same position, so you typing the question as if to your mother on the phone means that you don't make assumptions that we can understand the stuff you see on your screen and we can't. See what I mean?

Richmond Boateng 23-Jan-16 9:22am

I've understood your point

Richmond Boateng 23-Jan-16 9:29am

It really pains me that I can't upload a picture of what am doing

OriginalGriff 23-Jan-16 9:54am

:laugh:
Be glad you can't!
If you had any idea how many spammers, morons, idiots, and abusive asshats we get here, that would just love to post up "inappropriate" pictures... :sigh:
At one point last year we were getting several thousand such posts per hour! And it wouldn't take much for the site to go on a blacklist with corporate / university filters.

Richmond Boateng 23-Jan-16 10:30am

Okay.
But please help me out.
My problem is that am creating a school management system.
I want the software to be like the moment you select the class it displays the name,total marks scored in exams and lastly positions.

And I've tried to do all these. But my problem here now is how do I check and see the highest total marks and appoint a position like 1st,2nd,3rd.

Let's say if datagridview's column 1 is having these values
10
12
56
93.
Then on the next column2, I want the program to check for the higher total mark in column 1 and appoint a 1st to the higher mark, 2nd to the next higher mark, 3rd to next higher mark to the last mark. Where I want the 3rd,1st,2nd... display in column 2 but it will be in respective of what is in column 1

OriginalGriff 23-Jan-16 10:55am

There are quite a lot of ways to do that, but the best approach will depend on the rest of your system.
Where does the data the DGV displays come from? Do you set the DataSource to something? Is the DGV user-sortable (most are)?

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)