Isnull Check

Question

User-1499457942 posted

Hi

  I have a Date type Datafield in Sql . I want to check in Code Behind whether it is Not Null & 1753-01-01

Thanks

Answer 1

User-369506445 posted

hi

you can use below method

 public void getDataFromDB()
        {
            DateTime dt = new DateTime(1753,01,01);

            using (var con = new SqlConnection(connectionString))
            {
                con.Open();
                using (var com = new SqlCommand("select id,MyDate from MyTestTable", con))
                {
                    using (SqlDataReader myDataReader = com.ExecuteReader())
                    {
                        if (myDataReader.HasRows)
                        {
                            while(myDataReader.Read())
                            {
                                if (myDataReader[1] != null) // check for null
                                {
                                    DateTime myDate = myDataReader.GetDateTime(1);
                                    if (myDate.Date != dt.Date) // check for 1753-01-01
                                    {
                                        // put here your code
                                    }
                                }
                                
                            }
                            
                        }
                        
                    }
                }
            }
        }

Answer 2

User-1499457942 posted

Hi Vahid

  I am trying like this but it is not working

<asp:label runat="server" id="lblCDate" text='<%#Eval("CDate", "{0:dd/MM/yyyy}") %>'></asp:label>

if (e.Row.Cells[6].Text == "01/01/1753" || e.Row.Cells[7].Text == "01/01/1753" || e.Row.Cells[9].Text == "01/01/1753")
{
e.Row.Cells[6].Text = string.Empty;
e.Row.Cells[7].Text = string.Empty;
e.Row.Cells[8].Text = string.Empty;
e.Row.Cells[9].Text = string.Empty;
}

Thanks

Answer 3

User-1716253493 posted

if(IsDbNull(DataBinder.Eval(e.Row.DataItem,"cdate"))==true)
{

}
else
{
 if(DataBinder.Eval(e.Row.DataItem,"cdate").ToString()=='1753-01-01')
  {

  }
}

Answer 4

User-369506445 posted

please try below code

if (e.Row.RowType == DataControlRowType.DataRow)
            {
                var dateTime = e.Row.Cells[6].FindControl("lblCDate") as Label;
                if (!string.IsNullOrEmpty(dateTime.Text))
                {
                    DateTime defaultDate = new DateTime(1753, 01, 01);
                    if (DateTime.Parse(dateTime.Text).Date == defaultDate.Date)
                    {
                          // put here your code
                    }
                }
            }