你的位置:首页 > ASP.net教程

[ASP.net教程]csharp: DBNull and DateTime


/// <summary>    ///     /// </summary>    /// <param name="dateTime"></param>    /// <returns></returns>    public DateTime CheckDBNull(object dateTime)    {      if (dateTime == DBNull.Value)        return DateTime.MinValue;      else        return (DateTime)dateTime;    }    /// <summary>    ///     /// </summary>    /// <param name="field"></param>    /// <param name="data"></param>    /// <returns></returns>    public DateTime? ReadNullableDateTimefromReader(string field, IDataRecord data)    {      var a = data[field];      if (a != DBNull.Value)      {        return Convert.ToDateTime(a);      }      return null;    }    /// <summary>    ///     /// </summary>    /// <param name="field"></param>    /// <param name="data"></param>    /// <returns></returns>    public DateTime ReadDateTimefromReader(string field, IDataRecord data)    {      DateTime value;      var valueAsString = data[field].ToString();      try      {        value = DateTime.Parse(valueAsString);      }      catch (Exception)      {        throw new Exception("Cannot read Datetime from reader");      }      return value;    }	}

  

menu.IsMainMenu = (!DBNull.Equals(reader["IsMainMenu"], null)) ? (bool)reader["IsMainMenu"] : true;            menu.Remark = (!DBNull.Equals(reader["Remark"], null)) ? (string)reader["Remark"].ToString() : "";            menu.ParentMenuId = (!DBNull.Equals(reader["ParentMenuId"], null)) ? (int)reader["ParentMenuId"] : 0;            menu.TreeLevel = (!DBNull.Equals(reader["TreeLevel"], null)) ? (int)reader["TreeLevel"] : 0;            menu.SortIndex = (!DBNull.Equals(reader["SortIndex"], null)) ? (int)reader["SortIndex"] : 0;            menu.CreatedOn = CheckDBNull(reader["CreatedOn"]);// (!object.Equals(reader["CreatedOn"], null)) ? (DateTime)reader["CreatedOn"] : DateTime.Now;