VB.NET DATAGRID VIEW

Question

1.00/5 (1 vote)

See more:

Good Day to all.

I have a database which has a table field called "License_Expiration" that contains date and I will show this in a VB.NET datagridview

Now i just wanna ask How to change Datagridview Rows Colors by using the conditions below.

1.If License_Expiration will expire a month before the current date of expiration then the rows will change in dark green.

2.If License_Expiration will expire 10 days before the expiration then the color is light green

3.If License_Expiration meets the current date then it will turn red

4.If License_Expiration date has passed then it will turn yellow.

Please do help :(

Posted 10-Jul-13 17:43pm

Crixalis Paul

Add a Solution

Comments

Sergey Alexandrovich Kryukov 11-Jul-13 0:26am

System.Windows.Forms? Tag: "WinForms".
—SA

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-07-10T18:29:00

Solution 1

Please see: http://msdn.microsoft.com/en-us/library/1yef90x0.aspx[^].

It will explain you how to have individual cell styles for some cells. And then, for a cell's style, use the property System.Windows.Forms.DataGridViewCellStyle.BackColor:
http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcellstyle.backcolor.aspx[^].

—SA

Posted 10-Jul-13 18:29pm

Sergey Alexandrovich Kryukov

Comments

Crixalis Paul 11-Jul-13 0:43am

Good Tutorial but sorry i will not Accept it "Accept Solution"

Sergey Alexandrovich Kryukov 11-Jul-13 0:59am

Hm...
This is not a tutorial. It looks like it's not easy to help you. Not sure it worth the effort.
Take it easy,
—SA

Thanks7872 · Answer 2 · 2013-07-10T18:55:00

Solution 2

The above answer explains pretty well on how to change colors etc.

DataGridViewCellStyle.BackColor Property

Well,you can implement that in following event

C#

private void dataGridView1_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
{
   
}

Regards.. :laugh:

Posted 10-Jul-13 18:55pm

Thanks7872