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

Excel¡¢SQL¡¢VS6.0¡¢ÌرðÊÇ´¦ÀíListCtrlÓëExcel

Ò»¡¢¹ØÓÚCREATE TABLE tab1 (×Ö¶ÎÃû TEXT)ÖУ¬×Ö¶ÎÃûΪ“a.a.a»òa.a.b”ʱ£¬Ìáʾ£º
“×ֶζ¨ÒåÓï·¨´íÎó”
´ð£ºÔÚ×Ö¶ÎÃû×ÖÍâÃæ¼ÓÉÏ“[ ]”¾Í¿ÉÒÔÁË£¡
¶þ¡¢´´½¨Ò»¸öÒÔListCtrlµÚÒ»ÁÐΪEXCELµÚÒ»Ðеıí½á¹¹ ºÍ ²åÈëÒ»¸öÒÔListCtrlµÚNÁÐΪEXCELµÚ¶þÐеıí½á¹¹
      CListCtrl& resultListCtrl = GetListCtrl();
      CString   strDriver = "MICROSOFT EXCEL DRIVER (*.XLS)"; // ExcelÇý¶¯
      CString   strSQL    = _T("");
      CString   strExcelFile = _T("");
 
      //ÿÌì´´½¨Ò»¸ö.xlsÎļþ
      CTime tm;
      tm = CTime::GetCurrentTime();
      strExcelFile.Format("%s%d%d%d.xls",
            ((CDCMS_SGApp*)AfxGetApp())->m_strExcelPath, tm.GetYear(), tm.GetMonth(),tm.GetDay());
 
      ((CDCMS_SGApp*)AfxGetApp())->m_strCurExcelPath = strExcelFile;
 
      TRY
      {
           //Êý¾Ý¿â×Ö·û´®
            strSQL.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s",
                strDriver, strExcelFile, strExcelFile);
           //´´½¨Êý¾Ý¿â
            if( dbExcel.OpenEx(strSQL, CDatabase::noOdbcDialog) )
           {
                 //´´½¨±í½á¹¹µÄµÚÒ»ÐÐ Tag Name:
         &nbs


Ïà¹ØÎĵµ£º

Oracle ѧϰ£ºPL/SQLÑ­Ðò½¥½øÈ«ÃæÑ§Ï°½Ì³Ì

¿Î³Ìʮһ ÓëORACLE SERVER½»»¥
¡¡¡¡
¡¡¡¡±¾¿ÎÖØµã£º
¡¡¡¡1¡¢ÔÚPLSQLÖгɹ¦µÄдSELECTÓï¾ä
¡¡¡¡2¡¢¶¯Ì¬ÉùÃ÷PLSQL±äÁ¿ÀàÐÍÓëSIZE
¡¡¡¡3¡¢ÔÚPLSQLÖÐдDMLÓï¾ä
¡¡¡¡4¡¢ÔÚPLSQLÖпØÖÆÊÂÎñ
¡¡¡¡5¡¢È·¶¨DML²Ù×÷µÄ½á¹û
¡¡¡¡
¡¡¡¡×¢Ò⣺ÒÔÏÂʵÀýÖбêµã¾ùΪӢÎİë½Ç
¡¡¡¡
¡¡¡¡Ò»¡¢PLSQLÖеÄSQLÓï¾ä£º
¡¡¡¡SELECT¡¢DML¡¢CO ......

SQL×¢Èëʽ¹¥»÷ʵÀý½²½â

 ¸Õ¸Õ¸ßÖеÄһλͬѧÎÊÎÒÒ»µÀ±ÊÊÔÌ⣺Çë¼òÊöSQL×¢Èëʽ¹¥»÷¼°ÆäÔ­Àí¡£
 
£¨Q£º¹¥»÷£¿ÄѵÀÊÇ×öºÚ¿ÉÂ𣿣¿£©
¿ÉÒÔ°ÑÕâÖÖÐÐΪÀí½â³ÉºÚ¿ÍÐо¶£¬ÒòΪÕâÑù×öµÄÄ¿µÄ¾ÍÊÇ¡°·Ç·¨»ñÈ¡¡±¡£
 
£¨Q£ºÔõô×ö£¿£©
¿ÉÒÔ°´ÕÕÎÒÏÂÃæµÄ²½ÖèÒ»²½Ò»²½À´£¬´ó¼ÒÒ²¾Íµ±Ò»»Ø¡°ºÚ¿Í¡±ÁË¡££¨P.S. Õâ¿ÉÊÇÎÒ¡°¶À¼ÒÑÐÖÆ¡± ......

ÈçºÎɾ³ý SQL Server ±íÖеÄÖØ¸´ÐÐ

    Microsoft SQL Server ±í²»Ó¦¸Ã°üº¬Öظ´ÐкͷÇΨһÖ÷¼ü¡£Îª¼ò½àÆð¼û£¬ÔÚ±¾ÎÄÖÐÎÒÃÇÓÐʱ³ÆÖ÷¼üΪ“¼ü”»ò“PK”£¬µ«ÕâʼÖÕ±íʾ“Ö÷¼ü”¡£Öظ´µÄ PK Î¥·´ÁËʵÌåÍêÕûÐÔ£¬ÔÚ¹ØÏµÏµÍ³ÖÐÊDz»ÔÊÐíµÄ¡£SQL Server Óи÷ÖÖÇ¿ÖÆÖ´ÐÐʵÌåÍêÕûÐԵĻúÖÆ£¬°üÀ¨Ë÷Òý¡¢Î¨Ò»Ô¼Êø¡¢Ö÷¼üÔ¼Êøº ......

OracleÓëSQL ServerÊý¾Ý»¥ÓÃÐÔ£¨3£©

 ×÷Õß Haidong Ji  ·­Òë GoodKid
ÔÚÎҵĹØÓÚOracleºÍSQL Server »¥ÓÃÐÔµÄϵÁÐÎÄÕ part 1 ºÍ part 2 µ±ÖУ¬ÎÒÌÖÂÛÁËOracleºÍSQL Server µÄһЩ²»Í¬µãµÄ»°ÌâÒÔ¼°OracleÇý¶¯µÄ¿ÉÑ¡ÐÔ¡£ÔÚ±¾Ö÷ÌâÖУ¬ÎÒ½«ÌÖÂÛÒ»¸öÀ´×ÔOracle 10gµÄй¤¾ß£¬Oracle¼´Ê±¿Í»§¶Ë¡£
¶ÔÓÚOracle 10gÒÔǰµÄ°æ±¾£¬Èç¹ûÏ뽨Á¢ºÍOracleµÄÁ¬½Ó£¬ ......

perlÀûÓÃÄÚ´æÊ¹ÓÃsqlÓï¾ä

 ´ó¼ÒºÃ£¡×î½üÓÖÓÐÁËһЩģ¿éÓ÷¨µÄÐĵã¬ÄǾÍÊÇÀûÓÃÄ£¿éʹÄãµÄÄÚ´æ±ä³ÉÒ»¸öÐéÄâµÄÊý¾Ý¿âģʽ£¬Ê¹Äã¿ÉÒÔÔÚûÓÐÊý¾Ý¿âµÄÇé¿öÏ£¬½«txtÎļþµÄÊý¾Ý½øÐÐ sqlÓï¾ä´¦Àí£¬¸Ð¾õºÜÐÂÏʰɣ¬²»¹ýÕâ¸ö²»Óøе½¾ªÑÈ£¬PerlÒ»Ö±ÊǺÜÍêÃÀµÄ£¬¹þ¹þ£¬ÄÇÎÒÃǾÍÀ´¿´¿´Õâ¸öÉñÆæ°É£¡
ÐèÒª°²×° Ä£¿é£º
SQl::Library;
DBI 
ÏÂÃæÊdzÌÐò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ