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

[wyz6578397]

List Control 如何调用数据库里的数据,请高手帮忙啊..


我里面有四个字段...序员,标题,内容,时间.....


小弟在线等啊.....

[东文-桑晨]

什么数据库？使用关联。

[dybxxmdx]

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();

[hubofly]

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