高手快来指教啊!!! 怎么才能把select到的表里的数据,连接到VC的窗体列表控件中~!~备注:::是已经做好的大型系统,数据源这些已经连接.只是在这个大型系统中添加一个小的功能模块 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个到VC版问比较好吧。要是JAVA倒可以帮你看看 我的一个执行SQL语句传送到列表控件的函数,可供参考.下面是列表控件初始化属性,放在了对话框 OnInitDialog()中 m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FLATSB|LVS_EX_FULLROWSELECT); m_list.InsertColumn(0,"序号",LVCFMT_LEFT,0); m_list.InsertColumn(1,"物品名称",LVCFMT_LEFT,100); m_list.InsertColumn(2,"现有数量",LVCFMT_LEFT,70); m_list.InsertColumn(3,"物品类别名称",LVCFMT_LEFT,90); m_list.InsertColumn(4,"备注信息",LVCFMT_LEFT,120);void CGoodMainDlg::LoadBookInfo(CString sql){ m_list.DeleteAllItems(); CString fieldvalue; try { m_pRecord = m_pCon->Execute((_bstr_t)sql,NULL,adCmdText); int i = 0; if (m_pRecord->GetRecordCount()==0) return; else if (m_pRecord->GetRecordCount()==1) { if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodID")->Value); m_list.SetItemText(i,0,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodName")->Value); m_list.SetItemText(i,1,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("Count")->Value); m_list.SetItemText(i,2,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodTypeName")->Value); m_list.SetItemText(i,3,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("Desc1")->Value); m_list.SetItemText(i,4,fieldvalue); } else { while (! m_pRecord->ADOEOF && !m_pRecord->BOF) { m_list.InsertItem(100,""); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodID")->Value); m_list.SetItemText(i,0,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodName")->Value); m_list.SetItemText(i,1,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("Count")->Value); m_list.SetItemText(i,2,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodTypeName")->Value); m_list.SetItemText(i,3,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("Desc1")->Value); m_list.SetItemText(i,4,fieldvalue); i+=1; m_pRecord->MoveNext(); } } } catch(_com_error e) { AfxMessageBox(e.Description()); return; }} 字符串处理 如何制作一个在开始菜单旁边又不属于快速启动的图标? 问个弱弱的问题.关于选择控件的 在Ctooltipctl里怎样换行啊 如何知道进程中EXCEL有没有被启动?又如何知道EXCEL中的WORKBOOK有没有?小第不知道这2个判断高手救我下(在线等待) 指针返回问题,把我搞晕了 哪有MFC windows 程序设计 第二版的电子版呢? 要想编译的VC应用程序在没有安装VC的机器上运行,应该在VC编译时加上什么选项? 服务问题---在线等待,立马给分! 请问在VC中怎样读串口的信息? 组件创建失败 MFC 奇怪的异常
m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FLATSB|LVS_EX_FULLROWSELECT);
m_list.InsertColumn(0,"序号",LVCFMT_LEFT,0);
m_list.InsertColumn(1,"物品名称",LVCFMT_LEFT,100);
m_list.InsertColumn(2,"现有数量",LVCFMT_LEFT,70);
m_list.InsertColumn(3,"物品类别名称",LVCFMT_LEFT,90);
m_list.InsertColumn(4,"备注信息",LVCFMT_LEFT,120);
void CGoodMainDlg::LoadBookInfo(CString sql)
{
m_list.DeleteAllItems();
CString fieldvalue;
try
{
m_pRecord = m_pCon->Execute((_bstr_t)sql,NULL,adCmdText);
int i = 0;
if (m_pRecord->GetRecordCount()==0) return;
else if (m_pRecord->GetRecordCount()==1)
{
if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodID")->Value);
m_list.SetItemText(i,0,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodName")->Value);
m_list.SetItemText(i,1,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("Count")->Value);
m_list.SetItemText(i,2,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodTypeName")->Value);
m_list.SetItemText(i,3,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("Desc1")->Value);
m_list.SetItemText(i,4,fieldvalue);
}
else
{
while (! m_pRecord->ADOEOF && !m_pRecord->BOF)
{
m_list.InsertItem(100,""); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodID")->Value);
m_list.SetItemText(i,0,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodName")->Value);
m_list.SetItemText(i,1,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("Count")->Value);
m_list.SetItemText(i,2,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("GoodTypeName")->Value);
m_list.SetItemText(i,3,fieldvalue); if (fieldvalue = (TCHAR*)(_bstr_t)m_pRecord->GetFields()->GetItem("Desc1")->Value);
m_list.SetItemText(i,4,fieldvalue);
i+=1;
m_pRecord->MoveNext();
}
}
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
return;
}}