1

I want to compare cell(Datetime) value to empty or "None".If it is not empty or none then after it will add the parameter.I would greatly appreciate of your help.

Thanks,It gives me can't convert date time to string error

command.Parameters.AddWithValue("@pin", row.Cell(2).GetValue<string>());
command.Parameters.AddWithValue("@Amount", row.Cell(3).GetValue<int>());
 if(row.Cell(4).GetValue<DateTime>() == "" || row.Cell(4).GetValue<DateTime>() =="none")
{
}
command.Parameters.AddWithValue("@Expirydate", row.Cell(4).GetValue<DateTime>());
                            command.ExecuteNonQuery();
Amit Patel
  • 69
  • 9

2 Answers2

1

You can convert DateTime and comapre with a string by parsing as follows

(DateTime.Parse(date).ToString()=="None" || DateTime.Parse(date).ToString()==String.Empty())?true:False

Or you can use a try catch block to validate it.

Anirban Ghosh
  • 125
  • 2
  • 14
  • Gosh This doesn't work either.I have tried the `DateTime.Parse(row.Cell(4).GetValue()).ToString()=="None" || DateTime.Parse(row.Cell(4).GetValue()).ToString()==String.Empty())` – Amit Patel Jan 06 '17 at 20:01
0

Read it as a string first, check it, then convert it to a DateTime.

var s = row.Cell(4).GetValue<String>();
is (s != null && s != "" && s != "none")
{
    var d = DateTime.Parse(s);
    command.Parameters.AddWithValue("@Expirydate", d);
}

Or rethink the problem. Instead of relying on a magic number, just populate the expiration date whenever it is a valid date, like so:

var s = row.Cell(4).GetValue<String>();
DateTime d;
if (DateTime.TryParse(s, out d))
{
    command.Parameters.AddWithValue("@Expirydate", d);
}

Since "none" and "" are not valid dates, this will work, and in addition it will continue to work if someone puts in "None", "N/A", "Never", etc.

John Wu
  • 50,556
  • 8
  • 44
  • 80
  • Thank you man But I did with my way. `var expiry = row.Cell(4).GetValue(); if (expiry != "none" && expiry != "") { command.Parameters.AddWithValue("@Expirydate", DateTime.Parse(expiry)); } else { command.Parameters.AddWithValue("@Expirydate", Convert.DBNull); }` – Amit Patel Jan 06 '17 at 21:16