Select only rows that have 3 days ago

Question

0.00/5 (No votes)

See more:

Hi everyone,

I have a form with a DataGridView.
Using SQL I want to select all content from a table, in my case is
"SELECT * FROM dbo.ripRiparazioni;", and highlight with colour yellow only the rows that have a date of three days ago.

This is my code, at the moment:

C#

string SQLquery = "SELECT * FROM dbo.ripRiparazioni";

            SqlDataAdapter da = new SqlDataAdapter(SQLquery, connessione);

            DataSet ds = new DataSet();

            da.Fill(ds);

            dataGridView1.DataSource = ds.Tables[0];

How can I do?

Posted 25-Nov-14 4:25am

nicola_melc

Add a Solution

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)

OriginalGriff · Accepted Answer · 2014-11-25T04:39:00

Solution 1

First, the colour setting isn't in a vastly obvious place:

C#

myRow.DefaultCellStyle.BackColor = Color.Yellow;

Then, handle the DGV RowPrePaint event:

C#

private void MyView_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e)
    {
    DataGridView dgv = sender as DataGridView;
    if (dgv != null)
        {
        DataGridViewRow myRow = dataGridView1.Rows[e.RowIndex];
        DateTime date = (DateTime)myRow.Cells["InsertDate"].Value;
        if (date.Date >= DateTime.Now.AddDays(-3).Date)
            {
            myRow.DefaultCellStyle.BackColor = Color.Yellow;
            }
        }
    }

Posted 25-Nov-14 4:39am

OriginalGriff

Comments

Pikoh 25-Nov-14 10:42am

I'm curious. Why RowPrePaint and not CellFormatting? What are the avantages or differeces between them?

OriginalGriff 25-Nov-14 11:00am

Efficiency. CellFormatting is called for each cell before it is painted (and that can be a heck of a lot of events) - RowPrePaint is called once per row just before it is painted.

Pikoh 25-Nov-14 11:04am

Thank you very much. Now i know i've done it the wrong way for years :)

OriginalGriff 25-Nov-14 11:08am

Doesn't surprise me - the framework is so big it's easy to miss things: I do it all the time!

nicola_melc 25-Nov-14 11:24am

The code it's right, but I' ve an error.

When it finish the datagridview's rows, it continue to control and I have the error:

object reference not set to an instance of object

OriginalGriff 25-Nov-14 11:30am

I'd hazard a guess you didn't change the column name...

nicola_melc 25-Nov-14 11:36am

Yes, I changed the name of the column.
I am a noob, but not so much :)

OriginalGriff 25-Nov-14 11:40am

You'd be surprised how many people out there getting paid for this don't think of it...:sigh:

So which line is giving the exception? Which value is null according to the debugger?

nicola_melc 25-Nov-14 11:56am

In my table I have five lines.
With your code it works perfectly, but when debug is finished to control my "five lines" it continues to check other rows and goes in error.

OriginalGriff 25-Nov-14 12:11pm

Right - it paints rows which don't exist!
So check the RowIndex against the number of rows and do nothing it it is outside the valid range.

nicola_melc 26-Nov-14 8:37am

OK, I've solved.
Thank you OriginalGriff for the help.

Sorry, I'have another question for you.
How can I select, using an event, a specific datagridview's row ?

OriginalGriff 26-Nov-14 8:50am

"How can I select, using an event, a specific datagridview's row ?"
In what way?

nicola_melc 26-Nov-14 9:17am

No problem, I did it.

I used this code:

private void dgvListaRiparazioni_CellClick(object sender, DataGridViewCellEventArgs e)
{
DataGridView dgv = sender as DataGridView;

if (dgv == null)
return;

if (dgv.CurrentRow.Selected)
{
Chiusura chiusura = new Chiusura();
chiusura.ShowDialog();
}
}

OriginalGriff 26-Nov-14 9:58am

Good for you! Well done!