Question

MFC中数据库的数据无法插入到list control控件中

//如果我把这个注释掉就可以进界面了AddToGrid();
//如果没有注释进去就报错问题可能出在AddToGrid();上
BOOL CIDD_MEYZ::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
//设置列表视图的扩展风格
m_Grid.SetExtendedStyle(LVS_EX_FLATSB
|LVS_EX_FULLROWSELECT
|LVS_EX_HEADERDRAGDROP
|LVS_EX_ONECLICKACTIVATE
|LVS_EX_GRIDLINES);
//设置表头
m_Grid.InsertColumn(0,"员工编号",LVCFMT_LEFT,60,0);
m_Grid.InsertColumn(1,"员工姓名",LVCFMT_LEFT,60,1);
m_Grid.InsertColumn(2,"员工性别",LVCFMT_LEFT,60,2);
m_Grid.InsertColumn(3,"员工生日",LVCFMT_LEFT,60,3);
m_Grid.InsertColumn(4,"员工住址",LVCFMT_LEFT,100,4);
m_Grid.InsertColumn(5,"员工学历",LVCFMT_LEFT,60,5);
m_Grid.InsertColumn(6,"员工部门",LVCFMT_LEFT,60,6);
m_Grid.InsertColumn(7,"员工职务",LVCFMT_LEFT,60,7);
m_Grid.InsertColumn(8,"员工电话",LVCFMT_LEFT,80,8);
//m_Grid.SetBkColor(175);
AddToGrid();
m_C4.SetCurSel(0);
return TRUE;
}

void CIDD_MEYZ::AddToGrid()
{
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString sql;
int i = 0;
sql.Format("select * from tb_employee");
m_AdoConn.m_pRecordset = m_AdoConn.GetRecordSet((_bstr_t)sql);
while(!m_AdoConn.m_pRecordset->adoEOF)
{
m_Grid.InsertItem(i,"");
m_Grid.SetItemText(i,0,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("员工编号"));
m_Grid.SetItemText(i,1,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("员工姓名"));
m_Grid.SetItemText(i,2,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("员工性别"));
m_Grid.SetItemText(i,3,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("员工生日"));
m_Grid.SetItemText(i,4,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("员工住址"));
m_Grid.SetItemText(i,5,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("员工学历"));
m_Grid.SetItemText(i,6,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("员工部门"));
m_Grid.SetItemText(i,7,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("员工职务"));
m_Grid.SetItemText(i,8,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("员工电话"));
m_AdoConn.m_pRecordset->MoveNext();
i++;
}
m_AdoConn.ExitConnect();
}

Answer 1

list
control大数据量调用setitemtext确实比较耗时，一般多于2000条就能明细感觉慢，你可以使用list
control的虚表方式，可以秒杀。

Answer 2

建议重新封装个关于list控件的类，CSortCtrlList。。这个类的功能比vc中自带的功能强大了许多~~插入数据封装的有专门的函数~

Answer 3

m_Grid.InsertItem插入第0列
而不用
m_Grid.SetItemText(i,0,(char*)(

追问

m_Grid.InsertItem插入行
m_Grid.SetItemText(i,0,(char*)( 是插入列

追答

InsertColumn是插入列