database ado

来源：百度文库编辑：神马文学网时间：2024/04/28 14:59:49

void ReadRecordToList(CListCtrl m_Dlist,CString &szDb, char *sztab, _ConnectionPtr m_pConnect , _RecordsetPtr m_pRecordset)//
{
m_Dlist.DeleteAllItems();
// char *szDb;
// szDb="history";
FieldPtr ptr;
CString fieldname;
LPSTR fieldText;
long m_fieldscount,m_listcolumnscount;
int numline=0;
BOOL bn=OpenDatabase(m_pConnect,szDb,szServer,szUser,szPwd);
if (bn )
{
char szSQL[512];
sprintf(szSQL, sztab);
m_pRecordset.CreateInstance("ADODB.Recordset");
HRESULT hr = m_pRecordset->Open(szSQL,_variant_t(m_pConnect,true),adOpenDynamic,adLockPessimistic,adCmdText);
if(m_pRecordset->adoEOF)
{
AfxMessageBox("数据库表中没有记录信息！");
}
else
{
m_fieldscount=m_pRecordset->GetFields()->GetCount(); file://获得记录总数
m_listcolumnscount=m_fieldscount;
LV_ITEM lvitem;
lvitem.mask=LVIF_TEXT ;
lvitem.pszText="";
lvitem.iSubItem=0;
while(!m_pRecordset->adoEOF)
{
lvitem.iItem=numline;
m_Dlist.InsertItem(&lvitem);
file://读出数据写入到list中
for(long i=0;iptr=m_pRecordset->GetFields()->GetItem(i);
fieldname= (LPCTSTR)(_bstr_t)ptr->Name;
fieldText=fieldname.GetBuffer(fieldname.GetLength());
m_Dlist.SetItemText(numline,i,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect(fieldText));
}
numline++;
m_pRecordset->MoveNext();
}
}
if(m_pRecordset->State)
m_pRecordset->Close();
m_pRecordset.Release();
CloseDatabase(m_pConnect);
}
}

database ado ADO ADO简介 wwii database English database English database MySQL : create database, drop database ADO客户数据库编程 ADO的定义浅析ADO 事件模型数据库设计(Database Design) EXPORT TO MEMORY/DATABASE.... In-memory database 数据库设计(Database Design) SQL CREATE DATABASE 语句使用ADO.NET访问数据库 ADO.net学习记录 (一) firebird database (快速入門) firebird database (快速入門) MySQL database on Linux Tutorial [Laskey99] Section 4.2. Database Backup [Laskey99] Section 4.3. Database Recovery create database link的用法 Energy Citations Database (ECD) - - Document ...