术语“记录集”是指表中的一条记录还是指整个表中全部的记录呢?
除此之外想加问一个问题,如下代码中指针* pAdoDb和* pRs调用的两个Open()函数分别打开什么,前一个Open()比较清楚是打开一个数据库,那么后面这个Open()是打开什么呢?记录集?表?谢谢~~~CADODatabase* pAdoDb = new CADODatabase();
CString strConnection = "";strConnection = _T("Provider=MSDASQL;"
"PersistSecurityInfo=False;Trusted_Connection=Yes
Data Source=Access Sql Server;catalog=sampledb");if(pAdoDb->Open((LPCTSTR)strConnection))
{
CString strQry = _T("");
int numRecords; strQry.Format(_T("sp_StoreClientFields_ps '%s', %d"),
(LPCTSTR)strParam1, nParam2); CADORecordset* pRs = new CADORecordset(pAdoDb); if(!pRs->Open((LPCTSTR)strQry))
{
delete pRs;
delete pAdoDb;
return FALSE
} numRecords = pRs->GetRecordCount();
while(!pRs->IsEof())
{
CString strVal = _T("");
int nVal = 0;
//Get Numeric Field Value
pRs->GetFieldValue("NumField1", nVal) //Get String Field Data
pRs->GetFieldValue("StrField..", strVal)
DoSomething(nVal, strVal); pRs->MoveNext();
}
pRs->Close();
}
else
return FALSE;
除此之外想加问一个问题,如下代码中指针* pAdoDb和* pRs调用的两个Open()函数分别打开什么,前一个Open()比较清楚是打开一个数据库,那么后面这个Open()是打开什么呢?记录集?表?谢谢~~~CADODatabase* pAdoDb = new CADODatabase();
CString strConnection = "";strConnection = _T("Provider=MSDASQL;"
"PersistSecurityInfo=False;Trusted_Connection=Yes
Data Source=Access Sql Server;catalog=sampledb");if(pAdoDb->Open((LPCTSTR)strConnection))
{
CString strQry = _T("");
int numRecords; strQry.Format(_T("sp_StoreClientFields_ps '%s', %d"),
(LPCTSTR)strParam1, nParam2); CADORecordset* pRs = new CADORecordset(pAdoDb); if(!pRs->Open((LPCTSTR)strQry))
{
delete pRs;
delete pAdoDb;
return FALSE
} numRecords = pRs->GetRecordCount();
while(!pRs->IsEof())
{
CString strVal = _T("");
int nVal = 0;
//Get Numeric Field Value
pRs->GetFieldValue("NumField1", nVal) //Get String Field Data
pRs->GetFieldValue("StrField..", strVal)
DoSomething(nVal, strVal); pRs->MoveNext();
}
pRs->Close();
}
else
return FALSE;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货