³ÌÐòµ÷ÊÔÌáʾ¡°Access Violation¡±
ÎÒÓÃVCдÁ˸öÔÚʵÑéÊý¾ÝÖÐѰÕÒÐèÒªµÄÊýÖµ£¬Ã¿¸öʵÑéÎļþÖÐÓÐ2034¸öÊý¾Ý£¬ÆäÖв¨³¤ºÍÇ¿¶ÈÖµÒ»Ò»¶ÔÓ¦¡£Ö÷Òª´úÂëÈçÏ£º
void CFindPeakDlg::OnBegin()
{
// TODO: Add your control notification handler code here
CFileDialog openPre(true,"*.ROH",NULL,OFN_HIDEREADONLY|OFN_OVERWRITEPROMPT|OFN_ALLOWMULTISELECT,
"´ý´¦ÀíÎļþ(*.ROH)|*.ROH|ËùÓÐÎļþ(*.*)|*.*||");
DWORD MAXFILE = 256000; //ÉèÖûº³åÇø£¬
openPre.m_ofn.nMaxFile = MAXFILE;
char* pc = new char[MAXFILE];
openPre.m_ofn.lpstrFile = pc;
openPre.m_ofn.lpstrFile[0]=NULL;
int index1=0,x=0;//ÎļþÊýÁ¿Í³¼Æ
if(openPre.DoModal()==IDOK)
{
//Æô¶¯EXCEL·þÎñÆ÷£¬ÉèÖóõʼÊôÐÔ
_Application app;
Workbooks books;
_Workbook book;
Sheets sheets;
_Worksheet sheet;
Range range;
LPDISPATCH lpDisp;
COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
//Create Excel server (start Excel)
if(!app.CreateDispatch("Excel.Application"))
{
AfxMessageBox("Can't start Excel serve
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......