My97DatePicker日期控件查询SQL怎么写

2025-05-09 19:14:38
推荐回答(1个)
回答1:

My97DatePicker日期控件查询SQL怎么写

m_strSql = "Datetime BETWEEN" + "'"
                       + dtpStartDate.Value.ToShortDateString() + " " + dtpStartTime.Value.ToLongTimeString()
                       + "'" + "and" + "'" + dtpEndDate.Value.ToShortDateString()
                       + " " + dtpEndTime.Value.ToLongTimeString() + "'";