4,011
社区成员
发帖
与我相关
我的任务
分享
CDatabase m_database;
m_database.Open(NULL,FALSE,FALSE,_T("ODBC;Dsn=student;server=localhost;uid=;pwd=")); //打开数据源
DWORD dwExStyle = LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP|LVS_EX_ONECLICKACTIVATE;
m_ListTeacher.ModifyStyle(0,LVS_REPORT|LVS_SINGLESEL|LVS_SHOWSELALWAYS);
m_ListTeacher.SetExtendedStyle(dwExStyle);
m_ListTeacher.InsertColumn(0,"职工号",LVCFMT_CENTER,50,0);
m_ListTeacher.InsertColumn(1,"姓名",LVCFMT_CENTER,50,0);
m_ListTeacher.InsertColumn(2,"部门",LVCFMT_CENTER,50,0);
CString strSQL;
strSQL.Format("select * from user_pass");
//ListAll(strSQL); //打开教职工表,将所有记录显示在列表中
//return TRUE; // return TRUE unless you set the focus to a control
if (m_pSet->IsBOF())
{ // detects empty recordset
return;
}
int i=0;
do
{
m_pSet->MoveFirst();
while(!m_pSet->IsEOF())
{
m_ListTeacher.InsertItem(i,m_pSet->m_username);
m_ListTeacher.SetItemText(i,1,m_pSet->m_password);
m_ListTeacher.SetItemText(i,2,m_pSet->m_ID);
m_pSet->MoveNext(); //移到下一条记录
i++;
}
}while(i==100);