给出我写的一段代码: COleVariant var; CString str; CDetailInfoDlg dlg; int nTmp,nLength; str.Format("%d",nProgramID); str="select starttime,endtime,address,port from datascheme where programID="+str;
m_dbMan.SetQuery(str); m_dbMan.Query(1); nRows = m_dbMan.GetRowCount(); if(nRows>0) { m_dbMan.GetRecordset(1)->SetAbsolutePosition(1); //get starttime field value var = m_dbMan.GetRecordset(1)->GetFieldValue(0); str = COleDateTime(var).Format("%Y-%m-%d %H:%M"); str.Format("%s:%d",str,COleDateTime(var).GetSecond()); dlg.m_strStartTime = str; //get endtime field value var = m_dbMan.GetRecordset(1)->GetFieldValue(1); str = COleDateTime(var).Format("%Y-%m-%d %H:%M"); str.Format("%s:%d",str,COleDateTime(var).GetSecond()); dlg.m_strEndTime = str; //get Address field value var = m_dbMan.GetRecordset(1)->GetFieldValue(2); str = (LPCSTR) var.bstrVal; dlg.m_strAddress = str; //get Port field value var = m_dbMan.GetRecordset(1)->GetFieldValue(3); str.Format("%d",(int)var.iVal); dlg.m_strPort = str; }
用filter是庄一个madc2.6
COleVariant var;
CString str;
CDetailInfoDlg dlg;
int nTmp,nLength;
str.Format("%d",nProgramID);
str="select starttime,endtime,address,port from datascheme where programID="+str;
m_dbMan.SetQuery(str);
m_dbMan.Query(1);
nRows = m_dbMan.GetRowCount();
if(nRows>0)
{
m_dbMan.GetRecordset(1)->SetAbsolutePosition(1); //get starttime field value
var = m_dbMan.GetRecordset(1)->GetFieldValue(0);
str = COleDateTime(var).Format("%Y-%m-%d %H:%M");
str.Format("%s:%d",str,COleDateTime(var).GetSecond());
dlg.m_strStartTime = str; //get endtime field value
var = m_dbMan.GetRecordset(1)->GetFieldValue(1);
str = COleDateTime(var).Format("%Y-%m-%d %H:%M");
str.Format("%s:%d",str,COleDateTime(var).GetSecond());
dlg.m_strEndTime = str;
//get Address field value
var = m_dbMan.GetRecordset(1)->GetFieldValue(2);
str = (LPCSTR) var.bstrVal;
dlg.m_strAddress = str; //get Port field value
var = m_dbMan.GetRecordset(1)->GetFieldValue(3);
str.Format("%d",(int)var.iVal);
dlg.m_strPort = str;
}
Coledatetime ot
SElect MpgId FROM tMpgInfo WHERE filename = '%s' AND createtime = #%s#",tmp1,ot.Format()