星空网 > 软件开发 > 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;

  




原标题:csharp: DBNull and DateTime

关键词:

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

东莞快递到马来西亚:https://www.goluckyvip.com/tag/90907.html
广州寄马来西亚:https://www.goluckyvip.com/tag/90908.html
深圳发马来西亚的物流:https://www.goluckyvip.com/tag/90909.html
B2B业务:https://www.goluckyvip.com/tag/9091.html
深圳到马来西亚快递:https://www.goluckyvip.com/tag/90910.html
广东马来西亚物流:https://www.goluckyvip.com/tag/90911.html
怪物在游轮上复活的电影 怪物在游轮上复活的电影叫什么:https://www.vstour.cn/a/411230.html
在线旅游如何选择更优惠的旅游产品?:https://www.vstour.cn/a/411231.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流