如下语句:
CString strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dlg.m_strSrcName;1、能够给个比较全的语句
2、用ado连接要用数据源吗,我不想用数据源的连接方式
CString strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dlg.m_strSrcName;1、能够给个比较全的语句
2、用ado连接要用数据源吗,我不想用数据源的连接方式
http://download.csdn.net/source/1070271
GOOD LUCK~
CString LocalConnStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbname.mdb;";//access
{
CString Data;
//::CoInitialize(NULL);
std::vector<std::vector<CString> > table;
try
{
_RecordsetPtr PRs("ADODB.Recordset");
_ConnectionPtr PConn("ADODB.Connection"); PConn->Open((_bstr_t)LocalConnStr,"","",adModeUnknown);
if(PConn!=NULL)
{
_variant_t RecordsAffected;
_variant_t str_val;
PRs=PConn->Execute((_bstr_t)SQL,&RecordsAffected,adCmdText);
while(PRs!=NULL&&!PRs->adoEOF)
{
std::vector<CString> rs;
int cols=PRs->GetFields()->Count;
for(int i=0;i<cols;i++)
{
CString val;
str_val = PRs->GetCollect(long(i));
val= CString((char *)(_bstr_t)str_val);
rs.push_back(val);
}
table.push_back(rs);
PRs->MoveNext();
}
PRs->Close();
PConn->Close();
}
}
catch(_com_error e) //异常
{
// CString Data;
// Data.Format("SelectCMD connect database error,error catagory is %s\n",(char *)e.ErrorMessage());
// Debug(Data);
}
catch(...)
{
// Debug("SelectCMD error");
}
//::CoUninitialize();
return table;
}
CTime test=CTime::GetCurrentTime();
CString strDate = test.Format("%Y-%m-%d %H:%M:%S");
m_pRecordset.PutCollect("Date", _variant_t(strDate));
Date是日期的字段名
就再也插不进去数据了,AddNew和Update都有异常,
只能再建个新表才能再插入数据。
这个是怎么回事,