Expired date alert from gridview column

Question

0.00/5 (No votes)

See more:

I need a coding idea for for Expired Date alert by Red color from a gridview. GridView column name 'Date' and data type 'date'. i need this for code asp.net website. how can i do this correctly. Can i do this with timer clock?? i've tried this one

What I have tried:

C#

protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    for (int i = 0; i < GridView1.Rows.Count; i++)
    {
        DateTime date = Convert.ToDateTime(GridView1.Rows[i].Cells[3].Text);
        if (date < DateTime.Now)
        {
            GridView1.Rows[i].Cells[3].BackColor = System.Drawing.Color.Red;
        }
    }
}

Posted 29-Apr-16 19:36pm

Shwrv

Updated 1-May-16 7:49am

v4

Add a Solution

Comments

Gokulprasad05 30-Apr-16 1:42am

You doubt is past date are not enter into date field.

Shwrv 30-Apr-16 2:03am

if i want to do this, with set of timer clock [real time]. how can i do this, any idea?

VR Karthikeyan 30-Apr-16 2:01am

What is your issue here? explain it.

Gokulprasad05 30-Apr-16 2:14am

in page load ur datepickername.mindate=date.now()

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)

Karthik_Mahalingam · Accepted Answer · 2016-04-29T22:58:00

Solution 1

You shall Refresh the GridView data on a periodic manner using Timer

How to refresh GridView automatically using AJAX TimerEverything Technical[^]
Auto Refresh Update GridView In Asp.Net Ajax With Timer[^]

updated solution after OP's clarification:

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
       {
           if (e.Row.RowType == DataControlRowType.DataRow)
           {
             DateTime dt =  DateTime.ParseExact(e.Row.Cells[1].Text, "dd-MMM-yyyy hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
             if (dt < DateTime.Now)
                   e.Row.Style.Add("background-color", "red");
           }
       }

Posted 29-Apr-16 22:58pm

Karthik_Mahalingam

Updated 4-May-16 18:56pm

v2

Comments

Shwrv 4-May-16 3:49am

Date Expired alert from gridView column. need this @KARTHIK

Karthik_Mahalingam 4-May-16 4:14am

suppose if you have 10 rows and in that 3 rows are expired, then how will you show the alert ?

Shwrv 4-May-16 4:43am

yes this type rows have expired by current date. its must b dynamically. thnx @KARTHIK

Karthik_Mahalingam 4-May-16 4:55am

so you need to show the alert message box 3 times?

Shwrv 4-May-16 7:12am

those dates have expired gridview cell colors changed. or message box can be show for those dates.@KARTHIK

Karthik_Mahalingam 4-May-16 7:13am

then your code should work rite?

Shwrv 4-May-16 7:27am

yaap. please give me a solution.

Karthik_Mahalingam 4-May-16 7:29am

Then what is the issue.
Still I am not clear with your requiremt
Pls explain clearly

Shwrv 4-May-16 23:03pm

i want a expired date alert from gridview column named Exp_Date. gridview column cells become red those dates have expired. date can be checked by the current pc date. if u've any ques plz ask. thnx@KARTHIK

Karthik_Mahalingam 4-May-16 23:57pm

Shwrv, try this.

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (Convert.ToDateTime(e.Row.Cells[1].Text) < DateTime.Now)
e.Row.Style.Add("background-color", "red");
}
}

Shwrv 5-May-16 0:26am

thnx KARTHIK for reply. its giving error in convert datetime if statement. my Exp_Date column date type is 'datetime' . can it possible to ajax ext. timer .

Karthik_Mahalingam 5-May-16 0:29am

what is the value in that column ?

Shwrv 5-May-16 0:35am

column values-
04-May-2016 00:00:00
03-May-2016 00:00:00
06-May-2016 00:00:00

Karthik_Mahalingam 5-May-16 0:39am

try this

if (e.Row.RowType == DataControlRowType.DataRow)
{

DateTime dt = DateTime.ParseExact(e.Row.Cells[1].Text, "dd-MMM-yyyy hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
if (dt < DateTime.Now)
e.Row.Style.Add("background-color", "red");
}

Shwrv 5-May-16 0:52am

done. its works finally. thanx a lot. plz give this code in the solution i want to rate plz @KARTHIK

Karthik_Mahalingam 5-May-16 0:56am

done :)

Shwrv 5-May-16 1:05am

i want to vote your solution plz karthik give your code in the solution box . thnx :)

Karthik_Mahalingam 5-May-16 1:15am

Solution1 is my answer, Thanks :), and you have marked it as answer.

Shwrv 6-May-16 0:49am

@KARTHIK, there is a problem when gridview cell become null. i've tried but if condition given error.

if (!string.IsNullOrEmpty(DateText))
{
DateTime dateValue = DateTime.ParseExact(dateText, "dd-MMM-yyyy hh:mm:ss", null);
}
not worked.

Karthik_Mahalingam 6-May-16 0:55am

Wait.
I will come up with a solution

Karthik_Mahalingam 6-May-16 1:03am

try this

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (e.Row.Cells[1] != null)
{
string text = (e.Row.Cells[1].Text + "").Trim();
if (text.Length != 0)
{
DateTime dt = DateTime.ParseExact(text, "dd-MMM-yyyy hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
if (dt < DateTime.Now)
e.Row.Style.Add("background-color", "red");
}
}
}
}

Shwrv 6-May-16 1:15am

@KARTHIK, given an error- 'string can't recognized as a valid DateTime'. in the line [DateTime dt = DateTime.ParseExact(text, "dd-MMM-yyyy hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture);]

Karthik_Mahalingam 6-May-16 1:29am

what value you are getting in text variable.

Shwrv 6-May-16 2:02am

just for null value in any row cell, no color 'll show. that means no need to check those empty cells. others cells with datetime values will be check expired or not. @KARTHIK

Karthik_Mahalingam 6-May-16 2:13am

what is your table format?
few data pls

Shwrv 6-May-16 2:25am

Name - Type
id int
Name varchar(50)
Date date

Karthik_Mahalingam 6-May-16 2:28am

so you have to check only one column whcih is date
then the index will be 3

Shwrv 6-May-16 2:30am

yes. u r8

Karthik_Mahalingam 6-May-16 2:31am

change the cell color using below code

Karthik_Mahalingam 6-May-16 2:30am

e.Row.Cells[4].Style.Add("background-color", "red");

Shwrv 6-May-16 2:41am

@karthik, this have done b4. but the problem is, when cells haven't any value. error given when view in the browser

Karthik_Mahalingam 6-May-16 2:54am

post your code..

Shwrv 6-May-16 4:18am

@KARTHIK, i've managed. may b i'll need another help from you. b4 i'll try. if cant i'll inform you. thnx

Karthik_Mahalingam 6-May-16 4:26am

ok fine.

Shwrv 6-May-16 2:45am

i think that, empty value cant accept in the cell with this type[date]. type given- allow null