CWQ__xz__的博客

using NPOI.HSSF.UserModel;using NPOI.SS.UserModel;using NPOI.XSSF.UserModel;using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Data.OleDb;using System.Drawing;using System.IO;using System.Linq

1.使用DBNull.valuepile["age"]==DBNull.Value ? 0 : pile["age"]2.使用IsNull(“字段”)DataTable dt; //数据表对象已经接收了数据dt.rows[0].IsNull("字段"); //判断第一行数据的某个字段是否为空3.使用ToString()pile["age"].ToString().Equals("") ?0: pile["age"]...

//string类型：string time = "2021/01/01 12:12:12";time = Convert.ToDateTime(time).ToString("yyyy-MM-dd HH:mm:ss");//data类型DateTime dt = DateTime.Now;string s = dt.ToString("yyyy-MM-dd HH:mm:ss");————————————————版权声明：本文为优快云博主「CWQ__xz__」的原创文章，遵循CC 4.0 B