Compare Gridview date column to a given date in RowEditing event

See more:

C#

ASP.NET

Gridview

I am stumped but it seems so easy.

I have a Gridview of 11 columns. Column 8 is the date of when the record was added. This date is stored as a DateTime in an SQL Server table.

On the screen there is an edit button that takes the user to an update screen using a RowEditing event in the C# code behind.

What I want to do is compare this Add date to 08/01/2012. Any record added before this date brings up one update screen and every record added after this date brings up a different update screen.

The RowEditing event uses UrlParameterPasser to pass the record ID to the update program.

One thing I do not know how to do is to show the data in the cell (column 8) selected. I get an error that the string is not recognized as a valid DateTime and am not sure how to display what the program sees.

I am also not sure if the condition would work if I could get around the error.

Any help will be much appreciated.

Here is some of my code:

ASPX

<asp:BoundField DataField="WelfareNumber" HeaderText="Welfare#" SortExpression="WelfareNumber" ItemStyle-Wrap="false" />
<asp:BoundField DataField="CPLastName" HeaderText="CP Last Name" SortExpression="CPLastName" ItemStyle-Wrap="false" />
<asp:BoundField DataField="CPFirstName" HeaderText="First Name" SortExpression="CPFirstName" ItemStyle-Wrap="false" />
<asp:BoundField DataField="CPParticipantID" HeaderText="CP Par ID" SortExpression="CPParticipantID" ItemStyle-Wrap="false" />
<asp:BoundField DataField="NPLastName" HeaderText="NP Last Name" SortExpression="NPLastName" ItemStyle-Wrap="false" />
<asp:BoundField DataField="NPFirstName" HeaderText="First Name" SortExpression="NPFirstName" ItemStyle-Wrap="false" />
<asp:BoundField DataField="NPParticipantID" HeaderText="NP Par ID" SortExpression="NPParticipantID" ItemStyle-Wrap="false" />
<asp:BoundField DataField="Added" HeaderText="Added" SortExpression="Added" ItemStyle-Wrap="false" DataFormatString="{0:MM/dd/yyyy}" HtmlEncode="False" ItemStyle-ForeColor="LightSlateGray"/>
<asp:BoundField DataField="AddedBy" HeaderText="Added By" SortExpression="AddedBy" ItemStyle-Wrap="false" ItemStyle-ForeColor="LightSlateGray"/>
<asp:BoundField DataField="Updated" HeaderText="Updated" SortExpression="Updated" ItemStyle-Wrap="false" DataFormatString="{0:MM/dd/yyyy}" HtmlEncode="False" ItemStyle-ForeColor="LightSlateGray"/>
<asp:BoundField DataField="UpdatedBy" HeaderText="Updated By" SortExpression="UpdatedBy" ItemStyle-Wrap="false" ItemStyle-ForeColor="LightSlateGray" />

ASPX.CS

protected void gvCAD_RowEditing(object sender, GridViewEditEventArgs e)
   {
       // Pass textbox values to ReceiveQueryString.aspx
       string strWhereToGo;
       string strAdded = gvCADs.Rows[e.NewEditIndex].Cells[8].Text;
       DateTime strAdded1;
       strAdded1 = DateTime.Parse(strAdded);
       strAdded = strAdded1.ToString("MM/dd/yyyy");
       if (Convert.ToDateTime(strAdded) > Convert.ToDateTime("07/30/2012"))
       {
           strWhereToGo = "~/CallCenter/UpdateCAD_2012.aspx";
           //UrlParameterPasser urlWrapper = new UrlParameterPasser("~/CallCenter/UpdateCAD_2012.aspx");
       }
       else
       {
           strWhereToGo = "~/CallCenter/UpdateCAD.aspx";
           //UrlParameterPasser urlWrapper = new UrlParameterPasser("~/CallCenter/UpdateCAD.aspx");
       }
       //UrlParameterPasser urlWrapper = new UrlParameterPasser("~/CallCenter/UpdateCAD.aspx");
       UrlParameterPasser urlWrapper = new UrlParameterPasser(strWhereToGo);
       // Add some values
       string CAD = ((Label)gvCADs.Rows[e.NewEditIndex].FindControl("itCPCADID")).Text;
       urlWrapper["CPCADID"] = CAD;
       //urlWrapper["age"] = age.Text;

       // Redirect to the page, passing the parameters in the querystring
       urlWrapper.PassParameters();
   }