用这个语句来查询ACCESS数据库,但提示数据类型不符合:
cmd.CommandText = "select * from abc where z between #" & CDate(DTPicker1.Value) & " " & CDate(DTPicker2.Value) & "# and #" & CDate(DTPicker3.Value) & " " & CDate(DTPicker4.Value) & "#"
其中,DTPICKER控件已经设这为这样的格式:
DTPicker1.Format = dtpCustom
DTPicker2.Format = dtpCustom
DTPicker1.CustomFormat = "yyyy-MM-dd "
DTPicker2.CustomFormat = "tt:HH:mm:ss"
DTPicker3.Format = dtpCustom
DTPicker4.Format = dtpCustom
DTPicker3.CustomFormat = "yyyy-MM-dd "
DTPicker4.CustomFormat = "tt:HH:mm:ss"
但是每次都提示错误,DTPICKER 2和4的数值不是时间型的,而是一个日期2012-12-18,这是为什么?
cmd.CommandText = "select * from abc where z between #" & CDate(DTPicker1.Value) & " " & CDate(DTPicker2.Value) & "# and #" & CDate(DTPicker3.Value) & " " & CDate(DTPicker4.Value) & "#"
其中,DTPICKER控件已经设这为这样的格式:
DTPicker1.Format = dtpCustom
DTPicker2.Format = dtpCustom
DTPicker1.CustomFormat = "yyyy-MM-dd "
DTPicker2.CustomFormat = "tt:HH:mm:ss"
DTPicker3.Format = dtpCustom
DTPicker4.Format = dtpCustom
DTPicker3.CustomFormat = "yyyy-MM-dd "
DTPicker4.CustomFormat = "tt:HH:mm:ss"
但是每次都提示错误,DTPICKER 2和4的数值不是时间型的,而是一个日期2012-12-18,这是为什么?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货