通过DataRow和字段名columnName获得DateTime?

2017-01-25 16:58:10 访问(1388) 赞(0) 踩(0)


        /// <summary>
        /// 通过DataRow和字段名columnName获得DateTime?
        /// </summary>
        /// <param name="dr"></param>
        /// <param name="columnName"></param>
        /// <returns></returns>
        public DateTime? DateTimeNullGetByDataRowObj(DataRow dr, string columnName)
        {
            object obj = dr[columnName];

            if (obj == null || obj == DBNull.Value)
                return null;

            if (obj is DateTime)
                return (DateTime)obj;

            string str = obj.ToString();

            if (str.Length == 0)
                return null;

            DateTime theResult = DateTime.MinValue;

            if (DateTime.TryParse(str, out theResult))
                return theResult;

            return null;
        }