连接数据库:
CADODatabase *g_pDb;
CString strConnection = _T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb");
g_pDb = new CADODatabase;
g_pDb->Open(strConnection);
打开/关闭数据库:
pRs = new CADORecordset(g_pDb );
CString strSql = "SELECT * FROM Dic1" ;
if(pRs->Open((LPCTSTR)strSql))
{
}
else
{
AfxMessageBox(_T("Open DB Error!"));
}
pRs->Close();
delete pRs;
取得第一个数据:
pRs->MoveFirst();
取得最后一个数据:
pRs->MoveLast();
取得前一数据:
pRs->MovePrevious();
取得下一数据:
pRs->MoveNext();
取得数据:
pRs->GetFieldValue("字段名",kana);
取得表名,并添加到ComboBox控件中:
先在StdAfx.h中,添加
#import "c:/Program Files/Common Files/System/ADO/Msadox.dll"
在CPP文件中,实现如下:
CComboBox m_cmboDic;
ADOX::_CatalogPtr m_pCatalog = NULL;
m_pCatalog.CreateInstance(__uuidof(ADOX::Catalog));
m_pCatalog->PutActiveConnection((LPCTSTR)m_sConnectionStr);
ADOX::TablesPtr tables = m_pCatalog->Tables;
for(long i=0;i<tables->Count;i++)
{
ADOX::_TablePtr pTable = NULL;
pTable = tables->Item[i];
if(pTable->GetType()==_bstr_t("TABLE"))
{
CString TempName;
m_cmboDic.AddString(pTable->Name);
}
}
m_cmboDic.SetCurSel(0);