list Contrl 如何调用数据库数据!请高手旨点

Question

List Control 如何调用数据库里的数据,请高手帮忙啊..
我里面有四个字段...序员,标题,内容,时间.....
小弟在线等啊.....

Answer 1

m_REPORT.ModifyStyle(0, LVS_REPORT | LVS_SHOWSELALWAYS | LVS_SINGLESEL);
m_REPORT.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP);

CRect rect;
m_REPORT.GetClientRect(&rect);
int nInterval = rect.Width()/8; m_REPORT.InsertColumn(0,"No.",LVCFMT_LEFT,nInterval*0);
m_REPORT.InsertColumn(1,"YEAR",LVCFMT_LEFT,nInterval);
m_REPORT.InsertColumn(2,"MONTH",LVCFMT_LEFT,nInterval);
m_REPORT.InsertColumn(3,"DAY",LVCFMT_LEFT,nInterval/2);
m_REPORT.InsertColumn(4,"COMPANY",LVCFMT_LEFT,nInterval*2);
m_REPORT.InsertColumn(5,"LOCATION",LVCFMT_LEFT,nInterval*2); 
m_REPORT.InsertColumn(6,"WORKERS",LVCFMT_LEFT,nInterval); 
m_REPORT.InsertColumn(7,"HOURS",LVCFMT_LEFT,nInterval); 
//***************************************************************************
sSql.Format("select * from HOURS ORDER BY CYEAR DESC,CMONTH DESC,CDAY DESC ");
try
{
rst=cnn->Execute((_bstr_t)sSql,&RecordsAffected,adCmdText); 
}
catch(...)
{
MessageBox("查询记录出现错误!","信息");
  return false;
}

if(!rst->ADOEOF)
{
_variant_t vCount = rst->GetCollect((_variant_t) (long) 0);
int i=vCount.lVal;
int z=i+100;
rst->MoveFirst();
int row=0;
while (!rst->ADOEOF)
{

CString temp;
m_REPORT.InsertItem(LVIF_TEXT|LVIF_STATE, z,"", LVIS_SELECTED|LVIS_FOCUSED, LVIS_SELECTED|LVIS_FOCUSED, 0, 0); for(int j=0;j<8;j++)
{
temp=_com_util::ConvertBSTRToString((_bstr_t)rst->GetFields()->GetItem((long)j)->Value);
m_REPORT.SetItemText(row,j,temp);
} rst->MoveNext();
row+=1;
}
int x=row+30;
for(;row<x;row++)
{
m_REPORT.InsertItem(LVIF_TEXT|LVIF_STATE, z,"", LVIS_SELECTED|LVIS_FOCUSED, LVIS_SELECTED|LVIS_FOCUSED, 0, 0); for(int j=0;j<8;j++)
{
m_REPORT.SetItemText(row,j,"0");
}
}
}
else
{
int z=100;
for(int x=0;x<31;x++)
{
m_REPORT.InsertItem(LVIF_TEXT|LVIF_STATE, z,"", LVIS_SELECTED|LVIS_FOCUSED, LVIS_SELECTED|LVIS_FOCUSED, 0, 0); for(int j=0;j<8;j++)
{
m_REPORT.SetItemText(x,j,"0");
}
}
} rst->Close();

Answer 2

普通的数据库查询啦，
http://topic.csdn.net/t/20060109/13/4505809.html
参考一下