Question

VC++ 查询某段时间数据（ACCESS)

我是直接把时间选取器空间数据存进access的
现在需要根据开始时间和结束时间(2个时间控件）来查询
开始时间是m_start 结束时间是m_end 将查询结果插入grid
查询语句该怎么写 我下边这么写不对 应该是没获取对时间控件的值吧 求指教
void Ctongji::OnButton1()
{
m_Grid.DeleteAllItems();
ADO m_Ado; //声明ADO类对象
m_Ado.OnInitADOConn(); //连接数据库
CString SQL = "select * from detail where time between 'm_start and 'm_end' "; //设置查询字符串
m_Ado.m_pRecordset = m_Ado.OpenRecordset(SQL); //打开记录集
while(!m_Ado.m_pRecordset->adoEOF) //记录集不为空时循环
{
m_Grid.InsertItem(0,""); //向列表视图控件中插入行
//向列表视图控件中插入列
m_Grid.SetItemText(0,0,(char*)(_bstr_t)m_Ado.m_pRecordset->GetCollect("ID"));
m_Grid.SetItemText(0,1,(char*)(_bstr_t)m_Ado.m_pRecordset->GetCollect("kind"));
m_Grid.SetItemText(0,2,(char*)(_bstr_t)m_Ado.m_pRecordset->GetCollect("time"));
m_Grid.SetItemText(0,3,(char*)(_bstr_t)m_Ado.m_pRecordset->GetCollect("money"));
m_Grid.SetItemText(0,4,(char*)(_bstr_t)m_Ado.m_pRecordset->GetCollect("from"));
m_Grid.SetItemText(0,5,(char*)(_bstr_t)m_Ado.m_pRecordset->GetCollect("purpose"));
m_Grid.SetItemText(0,6,(char*)(_bstr_t)m_Ado.m_pRecordset->GetCollect("ps"));
m_Ado.m_pRecordset->MoveNext(); //将记录集指针移动到下一条记录
}
m_Ado.CloseRecordset(); //关闭记录集
m_Ado.CloseConn(); //断开数据库连接

}

Answer 1

这么写：
strA.Format("select * from detail where time between #%s# and #%s# " , (CStringA)m_start , (CStringA)m_end);