Calculation on gridview field

jmt · June 13th, 2013, 08:55 AM

I have a gridview that holds, among other things, a date which is pulled from a SQL db. How do I add a column after that date to the gridview which basically populates with either "expired" or "not expired" depending on if that date is past today's date or not? This column would appear with the rest of the data on page load. I've searched for examples like this and can't find anything close. Any help or a link to instruct how to do this is appreciated!

Erik Severiens · November 3rd, 2013, 11:11 AM

I did have the same issue, how to populate something from gridview and ended using listview :

Code:

 protected void ListView1_DataBound(object sender, EventArgs e)
    {
        if (RecordOK == true) ((Label)ListView1.InsertItem.FindControl("RecordIdLabel")).Text = recordNumber.ToString();      
    }

Success,
Erik

January 15th, 2014, 05:16 AM

i too want to get it sorted and looking closely to the thread .. expecting some apt suggestions to turn in favour sooner than later

mmorgan30 · February 5th, 2014, 01:40 AM

If this is a design time gridview then just add databond column that has binding expression that test the date i.e.

Code:

<%# ((DataItemType)Container.DataItem).DateFieldProperty > SomeDate ? "Expired" : "Not Expired" %>

Where DataItemType is the type of your data item
DateFieldProperty is the property of a DateTime object in your data item
SomeDate is a DateTime object item to test against

You can also do this behavior in code, add the column in the load event, set the value of the column in the data bound event base on what the DataItem