1.ADO连接
CAdoConnection adoCn;
CAdoRecordSet adoRs(&adoCn);
if(!adoCn.ConnectSQLServer(this->m_strDBSrc,this->m_strDBName,this->m_strDBUserid,this->m_strDBPwd))
return FALSE;
// "192.168.0.4",数据库名,登录验证的用户名,用户密码
int iStoreID = pXml->SelectSingleNode("root/head/store_id")->GetInt();
int iUserID = pXml->SelectSingleNode("root/head/user_id")->GetInt();
//2存储的初始与参数传值
CAdoCommand adoCmd(&adoCn,"ReSendInfoCue");
adoCmd.GetParameters()->Refresh();
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
//@seqID int , --消息ID
adoCmd.GetParameter(1)->Value = seqID ;
adoCmd.GetParameter(2)->Value = iStoreID;
adoCmd.GetParameter(3)->Value = iUserID;
//注:赋值的顺序要与存储过程一致 。参数数据类型的一致性转化如下
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
//3 存储的执行与记录集的获取
_RecordsetPtr pAdoRsMat = NULL;
pAdoRsMat = adoCmd.Execute(adCmdStoredProc);
if(pAdoRsMat == NULL)
return FALSE;
adoRs = pAdoRsMat;//返回记录集
pXml->ClearEles(pXml->SelectSingleNode("root/data"));
CString strInfo = "";
CString strURL = "";
CString strReatyCode,strStoreID,strEvent,strUserID;
int nCnt = 0;// 不能用 adoRs.GetRecordCount();
//4记录集的读取
if(adoRs.IsBOF() && adoRs.IsEOF())//判断是否是空记录集,若无这句判断,单下面while时,空记录集时会出错
nCnt = 0;
else
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
while(!adoRs.IsEOF())
{
adoRs.GetCollect("EventID",strEvent);
adoRs.GetCollect("ReatyCode",strReatyCode);
adoRs.GetCollect("Content",strInfo);
adoRs.GetCollect("URL",strURL);
adoRs.GetCollect("StoreID",strStoreID);
adoRs.GetCollect("UserID",strUserID);
nCnt++;
adoRs.MoveNext();
}