谁有ListView控件使用的例子,最好是结合ADO+Access2000 或者关于ListView的使用说明谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 给我你的E_mail,我给你发过去 [email protected] 也给我一份,非常感谢[email protected] 能不能给我一份,谢谢![email protected] //////////为列表控件添加列////////// m_userlist.InsertColumn(0,"用户ID",LVCFMT_LEFT,60); m_userlist.InsertColumn(1,"用户名",LVCFMT_LEFT,100); m_userlist.InsertColumn(2,"年龄",LVCFMT_LEFT,60); m_userlist.InsertColumn(3,"生日",LVCFMT_LEFT,100); //////////读取数据库中的信息添加到列表控件/////////// int nItem; _variant_t vUsername,vBirthday,vID,vOld; try { m_pRecordset.CreateInstance("ADODB.Recordset"); m_pRecordset->Open("SELECT * FROM users",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText); m_bSuccess = TRUE; while(!m_pRecordset->adoEOF) { vID = m_pRecordset->GetCollect("ID"); vUsername = m_pRecordset->GetCollect("username"); vOld = m_pRecordset->GetCollect("old"); vBirthday = m_pRecordset->GetCollect("birthday"); nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vID); m_userlist.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0); m_userlist.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0); m_userlist.SetItem(nItem,3,1,(_bstr_t)vBirthday,NULL,0,0,0); m_pRecordset->MoveNext(); } } catch(_com_error e)///捕捉异常 { AfxMessageBox("读取数据库失败!");///显示错误信息 } 楼上说完了,不过我的差不多,但有个异常捕获在while里,以便在一个记录行中出错后,还可以处理下一个记录 try { m_pRecordset.CreateInstance("ADODB.Recordset"); m_pRecordset->Open("SELECT * FROM users",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText); m_bSuccess = TRUE; while(!m_pRecordset->adoEOF) { try { vID = m_pRecordset->GetCollect("ID"); vUsername = m_pRecordset->GetCollect("username"); vOld = m_pRecordset->GetCollect("old"); vBirthday = m_pRecordset->GetCollect("birthday"); nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vID); m_userlist.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0); m_userlist.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0); m_userlist.SetItem(nItem,3,1,(_bstr_t)vBirthday,NULL,0,0,0); m_pRecordset->MoveNext(); } catch(_com_error e) { AfxMessageBox(e->ErrorMessage()); } } } catch(_com_error e) { AfxMessageBox(e->ErrorMessage()); } vs2005及其以上版本,release出来的程序运行不了 多个对话框数据的数据管理? 【散分】散分!我不想说理由 vs2005增加控件变量的问题 录音程序的问题 超难问题,大家发表一下意见,来者有分!(关于ldap的) 播放视频时怎么样实现倒放的功能????还有怎么样控制播放的速度???/ 枚举获得计算机支持的串口号,错在哪? 为什么我老是求不出int的值 从数据库取出数据的字节数 怎么模仿IE那样把HTML文件存成单个文件MHT 关于删除目录的问题?
[email protected]
[email protected]
m_userlist.InsertColumn(0,"用户ID",LVCFMT_LEFT,60);
m_userlist.InsertColumn(1,"用户名",LVCFMT_LEFT,100);
m_userlist.InsertColumn(2,"年龄",LVCFMT_LEFT,60);
m_userlist.InsertColumn(3,"生日",LVCFMT_LEFT,100);
//////////读取数据库中的信息添加到列表控件///////////
int nItem;
_variant_t vUsername,vBirthday,vID,vOld;
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM users",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
m_bSuccess = TRUE;
while(!m_pRecordset->adoEOF)
{
vID = m_pRecordset->GetCollect("ID");
vUsername = m_pRecordset->GetCollect("username");
vOld = m_pRecordset->GetCollect("old");
vBirthday = m_pRecordset->GetCollect("birthday");
nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vID);
m_userlist.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0);
m_userlist.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0);
m_userlist.SetItem(nItem,3,1,(_bstr_t)vBirthday,NULL,0,0,0); m_pRecordset->MoveNext();
}
}
catch(_com_error e)///捕捉异常
{
AfxMessageBox("读取数据库失败!");///显示错误信息
}
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM users",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
m_bSuccess = TRUE;
while(!m_pRecordset->adoEOF)
{
try
{
vID = m_pRecordset->GetCollect("ID");
vUsername = m_pRecordset->GetCollect("username");
vOld = m_pRecordset->GetCollect("old");
vBirthday = m_pRecordset->GetCollect("birthday");
nItem=m_userlist.InsertItem(0xffff,(_bstr_t)vID);
m_userlist.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0);
m_userlist.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0);
m_userlist.SetItem(nItem,3,1,(_bstr_t)vBirthday,NULL,0,0,0); m_pRecordset->MoveNext();
}
catch(_com_error e)
{
AfxMessageBox(e->ErrorMessage());
}
}
}
catch(_com_error e)
{
AfxMessageBox(e->ErrorMessage());
}