Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

³ÌÐòµ÷ÊÔÌáʾ¡°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.A


Ïà¹ØÎÊ´ð£º

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

VCÁ¬½ÓACCESSÊý¾Ý¿âÎÊÌâ - VC/MFC / Êý¾Ý¿â

ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í 
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......

dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌâ

ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:

public static Product[] SearchProducts(string keyword, int categoryID, int pa ......

MFC ACCESSÊý¾Ý¿âµÄÎÊÌâ - VC/MFC / Êý¾Ý¿â

ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......

ACCESSµÈ¿âʵÏÖÖðÈÕͳ¼Æ - MS-SQL Server / »ù´¡Àà

±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä  
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ