Conversion failed when converting date and/or time from character string.
string DateFrom, DateTo
cmd.Parameters.AddWithValue("dateFrom", DateFrom);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateFrom= dr["DateFrom"].ToString();
DateTo= dr["DateTo"].ToString();
In my database is stored as date.
Go to the complete details ...