4,012
社区成员
发帖
与我相关
我的任务
分享
CRect rect;
m_myList.GetClientRect(&rect);
int nColInterval = rect.Width()/5;
//插入列
m_myList.InsertColumn(0, _T("UserName"), LVCFMT_LEFT, nColInterval*3);
m_myList.InsertColumn(1, _T("Old"), LVCFMT_LEFT, nColInterval);
m_myList.InsertColumn(2, _T("blank"), LVCFMT_LEFT,
rect.Width()-4*nColInterval);
m_myList.DeleteAllItems();
_RecordsetPtr m_pRecordset;
_ConnectionPtr m_pConnection;
int nItem=0;
_bstr_t vSQL;
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)vSQL,_variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
if(!m_pRecordset->adoEOF) //如果记录不为空
{
int nIdx = 0;
while(!m_pRecordset->adoEOF)
{
m_myList.InsertItem(nIdx,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("username"));
m_myList.SetItemText(nIdx,2,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("old"));
m_pRecordset->MoveNext();
nIdx++;
}
}
m_pRecordset->Close();
}
catch (_com_error e)
{
e.Description();
e.ErrorMessage();
e.Source();
}
CRect rect;
m_myList.GetClientRect(&rect);
int nColInterval = rect.Width()/5;
//插入列
m_myList.InsertColumn(0, _T("id"), LVCFMT_LEFT, nColInterval);
m_myList.InsertColumn(1, _T("UserName"), LVCFMT_LEFT, nColInterval*3);
m_myList.InsertColumn(2, _T("Old"), LVCFMT_LEFT,
rect.Width()-4*nColInterval);
m_myList.DeleteAllItems();
_RecordsetPtr m_pRecordset;
int nItem=0;
_bstr_t vSQL="select * from users";
ADOConn m_ado;
m_ado.OnInitADOConn();
m_ado.GetRecordSet(vSQL);
//_RecordsetPtr& m_pRecordset
try {
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)vSQL,_variant_t((IDispatch*) (m_ado.m_pConnection),true),adOpenStatic,adLockOptimistic,adCmdText);
if(!(m_ado.m_pRecordset)->adoEOF) //如果记录不为空
{
int nIdx = 0;
while(!(m_ado.m_pRecordset)->adoEOF)
{
m_myList.InsertItem(nIdx,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("id"));
m_myList.SetItemText(nIdx,1,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("username"));
m_myList.SetItemText(nIdx,2,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("old"));
m_pRecordset->MoveNext();
nIdx++;
}
}
m_pRecordset->Close();
}
catch (_com_error e)
{
e.Description();
e.ErrorMessage();
e.Source(); }
m_myList.DeleteAllItems();
_RecordsetPtr m_pRecordset;
int nItem=0;
_bstr_t vSQL="select * from users";
ADOConn m_ado;
m_ado.OnInitADOConn();
m_ado.GetRecordSet(vSQL);
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)vSQL,_variant_t((IDispatch*) (m_ado.m_pConnection),true),adOpenStatic,adLockOptimistic,adCmdText);
if(!(m_ado.m_pRecordset)->adoEOF) //如果记录不为空
{
int nIdx = 0;
while(!(m_ado.m_pRecordset)->adoEOF)
{
m_myList.InsertItem(nIdx,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("id"));
m_myList.SetItemText(nIdx,1,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("username"));
m_myList.SetItemText(nIdx,2,(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("old"));
m_pRecordset->MoveNext();
nIdx++;
}
}
m_pRecordset->Close();
}
catch (_com_error e)
{
e.Description();
e.ErrorMessage();
e.Source();
}
ADOConn m_ado;
m_ado.OnInitADOConn();
int nItem=0;
_bstr_t vSQL;
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)vSQL,_variant_t((IDispatch*) (m_ado.m_pConnection),true),adOpenStatic,adLockOptimistic,adCmdText);