data table .select 筛选时间的有关问题

2012-06-06

data table .select筛选时间的问题DataRow[] rows dtNeed.Select(collect_timebetween + time.AddHou

data table .select 筛选时间的问题
DataRow[] rows = dtNeed.Select("collect_time between " + time.AddHours(-2).ToString() + " and " + time.AddHours(1).ToString() + "");

[解决办法]
DataRow[] rows = dtNeed.Select("collect_time between '" + time.AddHours(-2).ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + time.AddHours(1).ToString("yyyy-MM-dd HH:mm:ss") + "'");
再不行就
DataRow[] rows = dtNeed.Select("collect_time >= '" + time.AddHours(-2).ToString("yyyy-MM-dd HH:mm:ss") + "' and collect_time <= '" + time.AddHours(1).ToString("yyyy-MM-dd HH:mm:ss") + "'");
[解决办法]
这样试试

C# code

            DateTime time = DateTime.Now;            string sqlstr = "collect_time between '" + time.AddHours(-2).ToString() + "' and '" + time.AddHours(1).ToString() + "'";            DataTable dtNeed = new DataTable();            DataRow[] rows = dtNeed.Select(sqlstr);