String ks = dateTimePicker1.Value.ToShortDateString();
String js = dateTimePicker2.Value.ToShortDateString();查询语句为 String sql = "SELECT a.riqi, a.ygxm, b.gdmc, a.gtlxwz FROM (gongtian a INNER JOIN gongdi b ON a.gd_id = b.[id]) where " + ks1 + "< a.riqi <" + js1 + " order by a.[id] desc";其中 a.riqi的类型为字符型,数据格式为 2013/11/15如何来查询2个时间段中的数据呢?谢谢我是winform ,acc数据库
String js = dateTimePicker2.Value.ToShortDateString();查询语句为 String sql = "SELECT a.riqi, a.ygxm, b.gdmc, a.gtlxwz FROM (gongtian a INNER JOIN gongdi b ON a.gd_id = b.[id]) where " + ks1 + "< a.riqi <" + js1 + " order by a.[id] desc";其中 a.riqi的类型为字符型,数据格式为 2013/11/15如何来查询2个时间段中的数据呢?谢谢我是winform ,acc数据库
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货