vc 获取数据库数据问题

2012-07-18 03:29:42 218 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

vc利用ado进行多线程的数据库访问先描述一下我的问题公司开发一套新的打印服务，其中有多个线程可能同时对数据库进行访问，开始的时候用的是一个数据库连接，但是在多个线程同时访问的时候会报数据库异步访问和一些com异常，之后查阅了一些资料，发现在利用ado在进行多线程的数据库访问的时候，最好每个线程对应一个数据库连接，为了方便对这些链接进行管理，自己写了一个数据库连接池，将源码放到这里和大家分享，共同进步，希望阅读详情

vc 程序获取数据库表中的text类型数据在程序的文本控件中显示的数据并不完整

text数据类型应该如何操作跪求解————————

...全文

VC数据库编程中的打印控制 VC数据库编程中的打印控制　　VC数据库编程中的打印控制比较复杂，但它也给程序员最大的灵活性，而这种灵活性正是我们需要的。因为各行业、部门的报表一般都不太规整，特别是表头部分，二、三重嵌套的情况很常见。下面我们就开发中碰到的一些问题与同行们探讨。　　Document/View框架之外的打印　　熟悉VC的程序员都知道Microsoft 的AppWizard生成的应用程序框架中，可以选择免费的打印阅读详情

wssd89

数据库 4,017 成员 39,805 内容

+ 关注 + 加入社区

切换为时间正序

中年風雨 2012-07-22

打赏
举报

晕菜！兄弟，CListCtr控件是有长度限制的，除非你自己重载一个。



//MListCtrl.h

#if !defined(AFX_MLISTCTRL_H__9D014815_8777_4347_B97A_41D2763EAB79__INCLUDED_)

#define AFX_MLISTCTRL_H__9D014815_8777_4347_B97A_41D2763EAB79__INCLUDED_



#if _MSC_VER > 1000

#pragma once

#endif // _MSC_VER > 1000



class CMListCtrl : public CListCtrl {

public:

	CMListCtrl();

	virtual ~CMListCtrl();

public:

	BOOL SetItemText(int nItem, int nSubItem, LPCTSTR lpszText);

	CString GetItemText(int nItem, int nSubItem);

};



#endif // !defined(AFX_MLISTCTRL_H__9D014815_8777_4347_B97A_41D2763EAB79__INCLUDED_)





#include "stdafx.h"

#include "MListCtrl.h"



#ifdef _DEBUG

#undef THIS_FILE

static char THIS_FILE[]=__FILE__;

#define new DEBUG_NEW

#endif



//////////////////////////////////////////////////////////////////////

// Construction/Destruction

//////////////////////////////////////////////////////////////////////



CMListCtrl::CMListCtrl() {

	CListCtrl::CListCtrl();

}



CMListCtrl::~CMListCtrl() {

	CListCtrl::~CListCtrl();

}



BOOL CMListCtrl::SetItemText(int nItem, int nSubItem, LPCTSTR lpszText) {

	ASSERT(::IsWindow(m_hWnd));

	ASSERT((GetStyle() & LVS_OWNERDATA)==0);

	LVITEM lvi;

	lvi.iSubItem = nSubItem;

	lvi.pszText = (LPTSTR)lpszText;

	::SendMessage(m_hWnd, LVM_SETITEMTEXT, nItem, (LPARAM)&lvi);

	return (BOOL) ::SendMessage(m_hWnd, LVM_SETITEMTEXT, nItem, (LPARAM)&lvi);

}



CString CMListCtrl::GetItemText(int nItem, int nSubItem) {

	ASSERT(::IsWindow(m_hWnd));

	LVITEM lvi;

	memset(&lvi, 0, sizeof(LVITEM));

	lvi.iSubItem = nSubItem;

	CString str;

	int nLen = 1024; //修改此值，以改变Item长度限制

	int nRes;

	do {

		nLen *=2;

		lvi.cchTextMax = nLen;

		lvi.pszText = str.GetBufferSetLength(nLen);

		nRes = (int)::SendMessage(m_hWnd, LVM_GETITEMTEXT, (WPARAM)nItem, (LPARAM)&lvi);

	} while (nRes == nLen-1);

	str.ReleaseBuffer();

	return str;

}

下次找错误，一定要想清楚问题所在。

wssd89 2012-07-20

打赏
举报

是sql 数据库

重新说下问题：

在列表控件中显示数据库中的text类型数据在向list控件填充数据之前用Messagebox显示从数据库获取的数据是正确的但是（m_list.SetItemText(row,index+1,text);）填充数据后控件中显示的数据不完整而且回车，换行变成了||
m_list.GetItemText(nItem,12) 获取的数据也是不完整的了 ------

wssd89 2012-07-19

打赏
举报

"This page has three sections that need to be researched differently.
A) For Leads posted in the ""Projects out for Bid"" section - do the following
1. NOTE: You will need to drill into each posted lead to check for amendments
2. Click on the Project Name to access a details page
3. Click on the “Online Plans and Specifications link”
4. Click “I Agree”
5. If amendments are listed, do the following
6. Choose amendment as event type
7. Capture amendment date and number and paste to description
8. Return to the details page from step 2
9. Capture Bid title (bold at top of page) and Submission deadline, and paste to description
10. If no amendments are posted and/or lead is new, do the following
11. Choose Bid as event type
12. follow steps 8 & 9
13. Click on the “Advertisement” link and attach doc
NOTE: Add the following text to the end of the description for all leads: “Documents can be ordered online or by contacting DocuCopy, LLC, 3334 Brown Station Road, Columbia, Missouri 65202, Ph: (573) 814-1700, Fax: (573) 814-1725”

B) For leads posted in “Projects in Design” - do the following
1. Choose Advanced Notice as event type
2.. Capture table headers and paste to description
3. Capture lead line information and paste to description next to their appropriate headers

C) For leads posted in the “Projects that Recently Bid” section - do the following
1) Choose award as event type
2) Capture table headers and paste to description
3) Capture lead line information and paste to description next to their appropriate headers"

比如以上数据只获取了
"This page has three sections that need to be researched differently.
A) For Leads posted in the ""Projects out for Bid"" section - do the following
1. NOTE: You will need to drill into each posted lead to check for amendments
2. Click on the Project Name to access a details page

中年風雨 2012-07-19

打赏
举报

是access数据库？
access数据库text字段只能存255字符。

我写的测试程序:
http://download.csdn.net/detail/pardream/4438281

ouyh12345 2012-07-18

打赏
举报

怎么个不完整法？读到什么，显示又是什么？

vc 获取数据库数据问题

相关推荐