How to Retrieve null datetime in a texbox from gridview ?

Akhter HUssain

i am selection row from gridview in which leftdate is not available/empty ,so when i select that row editing then exception is raised that (String was not recognized as a valid DateTime.')

here is screen shot

here c# code

protected void Edit(object sender, EventArgs e)
{
using (GridViewRow row = (GridViewRow)((LinkButton)sender).Parent.Parent)
{
txtEmpID.ReadOnly = true;
txtEmpID.Text = row.Cells[0].Text;
txtEmpName.Text = row.Cells[1].Text;
txtFahterName.Text = row.Cells[2].Text;
//ddlSecID.ClearSelection();
//ddlSecID.Items.FindByText(row.Cells[3].Text).Selected = true;
//txtjdate.Text = row.Cells[4].Text;
txtCNIC.Text = row.Cells[3].Text;
ddlSecID.ClearSelection();
if (ddlSecID.Items.FindByText(row.Cells[4].Text) != null)
{
ddlSecID.Items.FindByText(row.Cells[4].Text).Selected = true;
}
if (ddlstatus.Items.FindByText(row.Cells[5].Text) != null)
{
ddlstatus.Items.FindByText(row.Cells[5].Text).Selected = true;
}
txtjdate.Text = Convert.ToDateTime(row.Cells[6].Text).ToString("dd/MM/yyyy");
if (!string.IsNullOrEmpty(txtldate.Text))
{
// DateTime date = DateTime.Parse(txtldate.Text);
txtldate.Text = null;
}
else
{
txtldate.Text = Convert.ToDateTime(row.Cells[7].Text).ToString("dd/MM/yyyy");
}
popup.Show();
}
}

26 Replies

Know the answer? Post it — somebody with the same question will find it here.

Priyanka Jain7y ago
Accepted answer
Update your condition as
txtldate.Text = (!string.IsNullOrWhiteSpace(txtldate.Text))?Convert.ToDateTime(row.Cells[7].Text).ToString("dd/MM/yyyy"): "";
Jared Madurai7y ago
if you are being returned a null value
use break points to chack the values and its data type while converting

use

txtldate.Text = Convert.ToDateTime(row.Cells[7].Text).ToString("dd/MM/yyyy");

with

if(!string.IsNullOrEmpty(row.Cells[7].Text))
txtldate.Text = Convert.ToDateTime(row.Cells[7].Text).ToString("dd/MM/yyyy");
Akhter HUssain7y ago
still same issue i removed trim ,if date exit,it popup window ,if date does not exit ,it raising exception
Priyanka Jain7y ago
It may be due to trim function try removing it
txtldate.Text = (!string.IsNullOrEmpty((row.Cells[7].Text)) ?Convert.ToDateTime(row.Cells[7].Text).ToString("dd/MM/yyyy"): "";
Akhter HUssain7y ago
Hi Priyanka jain,

Now issue is that if leftdate is exit is working fine on edit,but if left date is not exit/null then it raising exception .
Akhter HUssain7y ago
null is returning
Priyanka Jain7y ago
In your code what is row.Cells[7].Text returning please check in debugger
Akhter HUssain7y ago
here is
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MasterFilemp.aspx.cs" Inherits="WebApplication1.MasterFilemp" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">

    <link href="CSS/CSS.css" rel="stylesheet" type="text/css" />
<script src="scripts/jquery-1.3.2.min.js" type="text/javascript">script>
<script src="scripts/jquery.blockUI.js" type="text/javascript">script>


head>

<body style ="margin:50;padding:50">
    <form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
        <title>GridView Add, Edit, Delete AJAX Waytitle>
<asp:GridView ID="GridView1" runat="server"  Width = "550px"
AutoGenerateColumns = "false"  AlternatingRowStyle-BackColor = "#C2D69B"
HeaderStyle-BackColor = "green" AllowPaging ="true"
OnPageIndexChanging = "OnPaging"
PageSize = "15" >
<Columns>
<asp:BoundField DataField = "EnrollNumber" HeaderText = "Employee ID" HtmlEncode = "true" />
<asp:BoundField DataField = "EmpName" HeaderText = "Employee Name"  HtmlEncode = "true" />
<asp:BoundField DataField = "FatherName" HeaderText = "Father Name"  HtmlEncode = "true"/>
        <asp:BoundField DataField = "CNIC" HeaderText = "CNIC"  HtmlEncode = "true"/>
    <asp:BoundField DataField = "SecNam" HeaderText = "Section"  HtmlEncode = "true"/>
        <asp:BoundField DataField = "Status" HeaderText = "Status"  HtmlEncode = "true"/>
     <asp:BoundField DataField = "JoinDate" HeaderText = "Join Date"  HtmlEncode = "true"/>
      <asp:BoundField DataField = "LeftDate" HeaderText = "Left Date"  HtmlEncode = "true"/>
<asp:TemplateField ItemStyle-Width = "30px"  HeaderText = "EnrollNumber">
   <ItemTemplate>
       <asp:LinkButton ID="lnkEdit" runat="server" Text = "Edit" OnClick = "Edit">asp:LinkButton>
   ItemTemplate>
asp:TemplateField>
Columns>
<AlternatingRowStyle BackColor="#C2D69B"  />
asp:GridView>

<asp:Button ID="btnAdd" runat="server" Text="Add" OnClick = "Add" />

<%--<asp:Panel ID="pnlAddEdit" runat="server" CssClass="modalPopup" style = "display:none">--%>
    <asp:Panel ID="pnlAddEdit" runat="server" CssClass="modalPopup" style = "display:none;width: 350px; height: 300px;">
<asp:Label Font-Bold = "true" ID = "Label4" runat = "server" Text = "Employee Details" >asp:Label>
<br />
<table align = "center">
<tr>
<td>
<asp:Label ID = "Label1" runat = "server" Text = "EnrollNumber" >asp:Label>
td>
<td>
<asp:TextBox ID="txtEmpID" Width = "40px" MaxLength = "5" runat="server">asp:TextBox>
td>
tr>
<tr>
<td>
<asp:Label ID = "Label2" runat = "server" Text = "Employee Name" >asp:Label>
td>
<td>
<asp:TextBox ID="txtEmpName" runat="server">asp:TextBox>
td>
tr>
<tr>
<td>
<asp:Label ID = "Label3" runat = "server" Text = "Father Name" >asp:Label>
td>
<td>
<asp:TextBox ID="txtFahterName" runat="server">asp:TextBox>
td>
tr>
    <tr>
<td>
<asp:Label ID = "Label7" runat = "server" Text = "CNIC" >asp:Label>
td>
<td>
     <asp:TextBox ID="txtCNIC" runat="server">asp:TextBox>
    <cc1:MaskedEditExtender runat="server" TargetControlID="txtCNIC" Mask="99-9999-9999999-999"
                MessageValidatorTip="true" OnFocusCssClass="MaskedEditFocus" OnInvalidCssClass="MaskedEditError"
                MaskType="Number" InputDirection="LeftToRight" AcceptNegative="None" DisplayMoney="None"
                ErrorTooltipEnabled="True" ID="mskD" >cc1:MaskedEditExtender>
td>
tr>
    <tr>
<td>
<asp:Label ID = "Label5" runat = "server" Text = "Section" >asp:Label>
td>
<td>
<asp:DropDownList  id="ddlSecID" runat="server">asp:DropDownList>
td>
tr>
    <tr>
<td>
<asp:Label ID = "Label8" runat = "server" Text = "Status" >asp:Label>
td>
<td>
<asp:DropDownList  id="ddlstatus" runat="server">

            <asp:ListItem Text="Present" Value="1" />
                 <asp:ListItem Text="Left" Value="2" />
asp:DropDownList>
td>
tr>
<tr>
<td>

        <tr>
<td>
<asp:Label ID = "Label6" runat = "server"  Text = "Join Date" >asp:Label>
td>
<td>


   <asp:TextBox ID="txtjdate" runat="server" ReadOnly="true" CssClass="textbox">asp:TextBox>
                            <cc1:CalendarExtender ID="txtrechargedate_CalendarExtender" runat="server" Enabled="True"
                                TargetControlID="txtjdate" PopupPosition="BottomLeft">
                            cc1:CalendarExtender>
      <asp:TextBox ID="txtldate" runat="server" ReadOnly="false" CssClass="textbox">asp:TextBox>
                            <cc1:CalendarExtender ID="CalendarExtender1" runat="server" Enabled="True"
                                TargetControlID="txtldate" PopupPosition="BottomLeft">
                            cc1:CalendarExtender>



td>
tr>
<tr>
<td>
<asp:Button ID="btnSave" runat="server" Text="Save" OnClick = "Save" />
td>
<td>
<asp:Button ID="btnCancel" runat="server" Text="Cancel" OnClientClick = "return Hidepopup()"/>
td>
tr>
table>
asp:Panel>
<asp:LinkButton ID="lnkFake" runat="server">asp:LinkButton>
<cc1:ModalPopupExtender ID="popup" runat="server" DropShadow="false"
PopupControlID="pnlAddEdit" TargetControlID = "lnkFake"
BackgroundCssClass="modalBackground">
cc1:ModalPopupExtender>
ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID = "GridView1" />
<asp:AsyncPostBackTrigger ControlID = "btnSave" />
Triggers>
asp:UpdatePanel>
        <script type = "text/javascript">
    function BlockUI(elementID) {
        var prm = Sys.WebForms.PageRequestManager.getInstance();
        prm.add_beginRequest(function() {
            $("#" + elementID).block({ message: '<table align = "center"><tr><td>' +
     '<img src="images/loadingAnim.gif"/>td>tr>table>',
                css: {},
                overlayCSS: { backgroundColor: '#000000', opacity: 0.6
                }
            });
        });
        prm.add_endRequest(function() {
            $("#" + elementID).unblock();
        });
    }
    $(document).ready(function() {

        BlockUI("<%=pnlAddEdit.ClientID %>");
        $.blockUI.defaults.css = {};
    });
    function Hidepopup() {
        $find("popup").hide();
        return false;
    }


            //CNIC
           $("#txtCNIC").attr('maxlength', '16');
                $('#txtCNIC').on('keyup', function () {
                    var inp = $('#txtCNIC').val();
                    var noinp = inp.split('-').join('');
                    if (noinp.length > 4 && noinp.length <= 10) {
                        $('#txtCNIC').val(noinp.substring(0, 4) + '-' + noinp.substring(4, noinp.length));
                    } else if (noinp.length > 10 && noinp.length <= 14) {
                        $('#txtCNIC').val(inp.substring(0, 11) + "-" + noinp.substring(10, noinp.length));
                    }
            });

script>

    form>
body>
html>
Priyanka Jain7y ago
can you post your View code here
Akhter HUssain7y ago
i have 7 column ,please check below image,
Priyanka Jain7y ago
You please check you index properly and what row.Cells[7].Text) is returning

I think the problem is of index number defined

Check value while debugging as I counted in your image provided the grid view has 7 columns and column 7 should have as an index of 6
Akhter HUssain7y ago
same issue still persist with index 7
Priyanka Jain7y ago
in your image, you have condition row.Cells[6] which I think is incorrect.

Update your code properly which correct index then verify again. I think it is row.Cells[7]
Akhter HUssain7y ago
Hi priyanka ,
i used last provided code but error is same
Priyanka Jain7y ago
Your string matching in if condition will be your row.Cells[7].Text it will look alike
txtldate.Text = (!string.IsNullOrEmpty((row.Cells[7].Text).trim()) ?Convert.ToDateTime(row.Cells[7].Text).ToString("dd/MM/yyyy"): "";
Akhter HUssain7y ago
Hi Priyanka jain,

Your provided code working fine,but if date exit in a leftdate(column) ,then it is removing in popup window, i want to handle both condition that if date exit or not/null
Amit Mohanty7y ago
Hey try this
DateTime temp;
string date = "your date";
if (DateTime.TryParseExact(date, "yyyy-dd-MM hh:mm tt", CultureInfo.InvariantCulture, DateTimeStyles.None, out temp))
{
    txtldate.Text = temp.ToString();
}
else
{
    txtldate.Text = "";
}
Akhter HUssain7y ago
Hii Amit Gupta ,

Still have same issue after cleaning
Amit Gupta7y ago
As you said the value is null, so we checked it in if condition. If it is null or empty then it is not going to fall in that condition. can you try clean and rebuild the application and then try or it might contains some other values.
Akhter HUssain7y ago
Hi Amit
check below image with your provided code
Amit Gupta7y ago
Make sure, you have written the right one if(!string.IsNullOrEmpty(row.Cells[7].Text)) txtldate.Text = Convert.ToDateTime(row.Cells[7].Text).ToString("dd/MM/yyyy");
Akhter HUssain7y ago
Yes null value
Amit Gupta7y ago
Is it happening to this ? row.Cells[7].Text - whats is the value in it.
Akhter HUssain7y ago
HI Amit Gupta ,

this exception is raising again ,why this is happening.
Bidyasagar Mishra7y ago
replce your last if--else part to the below
if (!string.IsNullOrEmpty(row.Cells[7].Text).ToString("dd/MM/yyyy"))
                {
                    txtldate.Text = row.Cells[7].Text).ToString("dd/MM/yyyy");
                }
                else
                {
                    txtldate.Text = null;
                }
Amit Gupta7y ago
The value you are getting is null, do check the value before converting

Replace

txtldate.Text = Convert.ToDateTime(row.Cells[7].Text).ToString("dd/MM/yyyy");

with

if(!string.IsNullOrEmpty(row.Cells[7].Text))
txtldate.Text = Convert.ToDateTime(row.Cells[7].Text).ToString("dd/MM/yyyy");