110,538
社区成员
发帖
与我相关
我的任务
分享
//比如要查14号和15号的数据
string time1 = "2019-03-14";
string time2 = "2019-03-15";
//起始时间为当日零点、终止时间为次日零点
time1 = "2019-03-14 00:00:00";
time2 = Convert.ToDateTime(time2).AddDays(1).ToString() + "00:00:00";
string sql = string.Format("select*from Table where time between {0} and {1}",time1,time2);
DataView 筛选表 = DataTable数据表.DefaultView;
string 点选 = “查询“;
筛选表.RowFilter = "性味归经 Like '%" + 点选 + "%'";