c# datagridview sorting by row background color

Question

1.00/5 (1 vote)

See more:

Hello All,

I have a datagridview with three columns on the windows form. Each row is colored on some basis with Red, Green and Yellow colors.

Now what I want is when I click on column headers I want to sort them according to colors. Like in ascending order the grid will show the Green rows first then Yellow and then the Red and in descending order the opposite.

How it is possible?

Awaiting your response.

Thanks
Kapil

Posted 17-Mar-12 3:39am

Kapil Waghe

Add a Solution

2 solutions

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)

ProEnggSoft · Accepted Answer · 2012-03-17T23:28:00

An alternative is to create one field in the database for color code, say ColorCode, assign the values say 1 - Green, 2 - Yellow, 3 - Red.
Then based on this field, apply color to the rows of the DataGridView in CellFormatting event.

C#

private void  dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{

    if (e.RowIndex < 0 || dataGridView1.Rows[e.RowIndex]
                .Cells["ColorCode"].Value==DBNull.Value)
        return;
    int colorCode = (int)dataGridView1.Rows[e.RowIndex].Cells["ColorCode"].Value;
    e.CellStyle.BackColor = colorCode == 1 ? Color.Green : 
            colorCode == 2 ? Color.Yellow : Color.Red;
}

Then click on the column header of ColorCode column, to sort the rows according to the ColorCode.

ProEnggSoft · Accepted Answer · 2012-03-19T14:09:00

You cannot sort the hidden column visually by clicking on the DataGridView as the column is not visible. One of the following options can be used, to sort the hidden column, using the bindingSource1 to which the DataGridView is bound.

Option1.

Use buttons, say Button1 and Button2 to sort the hidden column in ascending and descending order respectively. Then in the Click event of buttons set the Sort property of bindingSource1 as follows

C#

//Button1 click event
bindingSource1.Sort = "ColorCode";
//Button2 click event
bindingSource1.Sort = "ColorCode DESC";

Option2

By default the DataGridView sorts the column in ascending and descending order alternatively, when the header of that column is clicked. To disable this the SortMode property of Column can be set to NotSortable and then the ColumnHeaderMouseClick can be handled to sort the ColorCode column

C#

dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.NotSortable;

private void dataGridView1_ColumnHeaderMouseClick(object sender, 
DataGridViewCellMouseEventArgs e) {
//If first column header is clicked sort ColorCode in ascending order
    if (e.ColumnIndex==0)
        bindingSource1.Sort = "ColorCode";
//If second column header is clicked sort ColorCode in descending order
    else if (e.ColumnIndex==1)
        bindingSource1.Sort = "ColorCode DESC";
}

c# datagridview sorting by row background color

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0