// TODO: Add extra initialization here
m_cList.SetExtendedStyle(LVS_EX_GRIDLINES);
// 设置List的列
m_cList.InsertColumn(0, "用户ID", LVCFMT_LEFT, 50);
this->m_cList.SetTextBkColor(RGB(72, 72, 25)); //设置颜色
this->m_cList.SetTextColor(RGB(155, 195, 185));
m_cList.InsertColumn(1, "用户名", LVCFMT_LEFT, 50);
m_cList.InsertColumn(2, "超级用户", LVCFMT_LEFT, 30);
m_cList.InsertColumn(3, "管理员", LVCFMT_LEFT, 30);
RefreshData();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CUserRecord::RefreshData()
{
if(!db.IsOpen()){
db.Open("use");
}
UpdateData();
m_cList.DeleteAllItems();
CRecordset m_recordset(&db);
CString strSQL;
strSQL.Format("select * from user");
m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
CDBVariant varValue;
if(m_recordset.GetRecordCount()!=0) m_recordset.MoveFirst();
char buf[40];
int i=0;
m_cList.DeleteAllItems(); // 清除列表框内容
while(!m_recordset.IsEOF())
{
int temp=0;
m_cList.InsertItem(i,"");
//m_recordset.GetFieldValue(temp,varValue);
//sprintf(buf,"%d",varValue.m_iVal);
//m_cList.SetItemText(i,0,buf);
m_recordset.GetFieldValue(temp,varValue);
m_cList.SetItemText(i,0,varValue.m_pstring->GetBuffer(1));
m_recordset.GetFieldValue(1,varValue);
m_cList.SetItemText(i,1,varValue.m_pstring->GetBuffer(1)); m_recordset.GetFieldValue(2,varValue);
m_cList.SetItemText(i,2,varValue.m_pstring->GetBuffer(1));
m_recordset.GetFieldValue(3,varValue);
sprintf(buf,"%d",varValue.m_boolVal);
m_cList.SetItemText(i,3,buf); m_recordset.GetFieldValue(4,varValue);
sprintf(buf,"%d",varValue.m_boolVal);
m_cList.SetItemText(i,4,buf); m_recordset.MoveNext();
i++;
}
m_cList.SetExtendedStyle(LVS_EX_GRIDLINES);
// 设置List的列
m_cList.InsertColumn(0, "用户ID", LVCFMT_LEFT, 50);
this->m_cList.SetTextBkColor(RGB(72, 72, 25)); //设置颜色
this->m_cList.SetTextColor(RGB(155, 195, 185));
m_cList.InsertColumn(1, "用户名", LVCFMT_LEFT, 50);
m_cList.InsertColumn(2, "超级用户", LVCFMT_LEFT, 30);
m_cList.InsertColumn(3, "管理员", LVCFMT_LEFT, 30);
RefreshData();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CUserRecord::RefreshData()
{
if(!db.IsOpen()){
db.Open("use");
}
UpdateData();
m_cList.DeleteAllItems();
CRecordset m_recordset(&db);
CString strSQL;
strSQL.Format("select * from user");
m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
CDBVariant varValue;
if(m_recordset.GetRecordCount()!=0) m_recordset.MoveFirst();
char buf[40];
int i=0;
m_cList.DeleteAllItems(); // 清除列表框内容
while(!m_recordset.IsEOF())
{
int temp=0;
m_cList.InsertItem(i,"");
//m_recordset.GetFieldValue(temp,varValue);
//sprintf(buf,"%d",varValue.m_iVal);
//m_cList.SetItemText(i,0,buf);
m_recordset.GetFieldValue(temp,varValue);
m_cList.SetItemText(i,0,varValue.m_pstring->GetBuffer(1));
m_recordset.GetFieldValue(1,varValue);
m_cList.SetItemText(i,1,varValue.m_pstring->GetBuffer(1)); m_recordset.GetFieldValue(2,varValue);
m_cList.SetItemText(i,2,varValue.m_pstring->GetBuffer(1));
m_recordset.GetFieldValue(3,varValue);
sprintf(buf,"%d",varValue.m_boolVal);
m_cList.SetItemText(i,3,buf); m_recordset.GetFieldValue(4,varValue);
sprintf(buf,"%d",varValue.m_boolVal);
m_cList.SetItemText(i,4,buf); m_recordset.MoveNext();
i++;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货