VBº¯Êý¶¨Òå
Ãû³Æ ÀàÐÍ ËµÃ÷
abort º¯Êý ÒýÆð·ÅÆúµÄÒâÍâ´¦Àí
abs º¯Êý ¾ø¶ÔÖµº¯Êý
addexitproc º¯Êý ½«Ò»¹ý³ÌÌí¼Óµ½ÔËÐÐʱ¿âµÄ½áÊø¹ý³Ì±íÖÐ
addr º¯Êý ·µ»ØÖ¸¶¨¶ÔÏóµÄµØÖ·
adjustlinebreaks º¯Êý ½«¸ø¶¨×Ö·û´®µÄÐзָô·ûµ÷ÕûΪcr/lfÐòÁÐ
align ÊôÐÔ Ê¹¿Ø¼þλÓÚ´°¿Úij²¿·Ö
alignment ÊôÐÔ ¿Ø¼þ±êÇ©µÄÎÄ×ÖλÖÃ
allocmem º¯Êý ÔÚ¶ÑÕ»ÉÏ·ÖÅ䏸¶¨´óСµÄ¿é
allowgrayed ÊôÐÔ ÔÊÐíÒ»¸ö»Ò¶ÈÑ¡Ôñ
ansicomparestr º¯Êý ±È½Ï×Ö·û´®£¨Çø·Ö´óСд£©
ansicomparetext º¯Êý ±È½Ï×Ö·û´®£¨²»Çø·Ö´óСд£©
ansilowercase º¯Êý ½«×Ö·ûת»»ÎªÐ¡Ð´
ansiuppercase º¯Êý ½«×Ö·ûת»»Îª´óд
append º¯Êý ÒÔ¸½¼ÓµÄ·½Ê½´ò¿ªÒÑÓеÄÎļþ
arctan º¯Êý ÓàÇк¯Êý
assignfile º¯Êý ¸øÎļþ±äÁ¿¸³Ò»ÍⲿÎļþÃû
assigned º¯Êý ²âÊÔº¯Êý»ò¹ý³Ì±äÁ¿ÊÇ·ñΪ¿Õ
autosize ÊôÐÔ ×Ô¶¯¿ØÖƱêÇ©µÄ´óС
backgrounddi2001.jpg ÊôÐÔ ±³¾°É«
beginthread º¯Êý ÒÔÊʵ±µÄ·½Ê½½¨Á¢ÓÃÓÚÄÚ´æ¹ÜÀíµÄÏß³Ì
bevelinner ÊôÐÔ ¿Ø¼þ·½¿òµÄÄÚ¿ò·½Ê½
bevelouter ÊôÐÔ ¿Ø¼þ·½¿òµÄÍâ¿ò·½Ê½
bevelwidth ÊôÐÔ ¿Ø¼þ·½¿òµÄÍâ¿ò¿í¶È
blockread º¯Êý ¶ÁÒ»¸ö»ò¶à¸ö¼Ç¼µ½±äÁ¿ÖÐ
blockwrite º¯Êý ´Ó±äÁ¿ÖÐдһ¸ö»ò¶à¸ö¼Ç¼
borderstyle ÊôÐÔ ±ß½çÀàÐÍ
borderwidth ÊôÐÔ ±ß½ç¿í¶È
break ÃüÁî ÖÕÖ¹for¡¢while¡¢repeatÑ»·Óï¾ä
brush ÊôÐÔ »Ë¢
caption ÊôÐÔ ±êÇ©ÎÄ×ÖµÄÄÚÈÝ
changefileext º¯Êý ¸Ä±äÎļþµÄºó׺
chdir º¯Êý ¸Ä±äµ±Ç°Ä¿Â¼
checked ÊôÐÔ È·¶¨¸´Ñ¡¿òÑ¡ÖÐ״̬
chr º¯Êý ·µ»ØÖ¸¶¨ÐòÊýµÄ×Ö·û
closefile ÃüÁî ¹Ø±Õ´ò¿ªµÄÎļþ
color ÊôÐÔ ±êÇ©µÄÑÕÉ«
columns ÊôÐÔ ÏÔʾµÄÁÐÊý
comparestr º¯Êý ±È½Ï×Ö·û´®£¨Çø·Ö´óСд£©
concat º¯Êý ºÏ²¢×Ö·û´®
continue ÃüÁî ¼ÌÐøfor¡¢while¡¢repeatµÄÏÂÒ»¸öÑ»·
copy º¯Êý ·µ»ØÒ»×Ö·û´®µÄ×Ó´®
cos º¯Êý ÓàÏÒº¯Êý
ctl3d ÊôÐÔ ÊÇ·ñ¾ßÓÐ3dЧ¹û
cursor ÊôÐÔ Êó±êÖ¸ÕëÒÆÈëºóµÄÐÎ×´
date º¯Êý ·µ»Øµ±Ç°µÄÈÕÆÚ
datetimetofiledate º¯Êý ½«delphiµÄÈÕÆÚ¸ñʽת»»ÎªdosµÄÈÕÆÚ¸ñʽ
datetimetostr º¯Êý ½«ÈÕÆÚʱ¼ä¸ñʽת»»Îª×Ö·û´®
datetimetostring º¯Êý ½«ÈÕÆÚʱ¼ä¸ñʽת»»Îª×Ö·û´®
datetostr º¯Êý ½«ÈÕÆÚ¸ñʽת»»Îª×Ö·û´®
dayofweek º¯Êý ·µ»ØÐÇÆÚµÄÊýÖµ
dec º¯Êý µÝ¼õ±äÁ¿Öµ
decodedate º¯Êý ½«ÈÕÆÚ¸ñʽ·Ö½âΪÄêÔÂÈÕ
decodetime º¯Êý ½«Ê±¼ä¸ñʽ·Ö½âΪʱ¡¢·Ö¡¢Ãë¡¢ºÁÃë
delete º¯Êý ´Ó×Ö·û´®ÖÐɾ³
Ïà¹ØÎĵµ£º
¿ÉÒÔɸѡÊý¾Ý£¬µ«²»ÄÜÊDZê×¼µÄSQLÓï¾ä£º
Me.DsUserManager1.Tables(0).Select("id > 5 and id <20")
---------------------------------------------------------------
1.ɸѡ£º
dataset.tables("tabname").select("id=1")'Ï൱ÓÚSQLÖÐWHEREºóµÄÌõ¼þÄÚÈÝ
2.±£´æµ½ÄÄ£¿Õâµ¹ÊDz»Öª ......
³¤¾ÃÒÔÀ´£¬ÓÉÓÚ²»ÄÜÖ±½Ó»ñµÃVBÀà³ÉÔ±º¯ÊýÖ¸Õ룬ÒòΪÎÞ·¨ÔÚVBµÄÀàÄ£¿éÖÐÖ±½ÓʹÓö¨Ê±Æ÷¿Ø¼þ»ò¶¨Ê±Æ÷API£¬»ùÓÚ°³±àдµÄ»ñµÃÀà³ÉÔ±º¯ÊýÖ¸ÕëµÄº¯Êý£¬°³±àдÁËÕâ¸ö´ø¶¨Ê±Æ÷¹¦ÄܵÄÀ࣬ϣÍû¸øÅóÓÑÃÇһЩÆô·¢¡£
Ò»¡¢Ð½¨Ò»¸öÀ࣬ÀàÃû³ÆÎªclsTimer£¬Àà´úÂëÈçÏ£º
Option Explicit
'* ** ......
¼òµ¥¶øÊµÓõĺϲ¢ExcelÎļþµÄº¯Êý£¬Äܹ»½«¶à¸öXLSÎļþÖÐÖ¸¶¨ÊýÁ¿µÄ¹¤×÷±í×Ô¶¯ºÏ²¢µ½Ò»¸öXLSÎļþÀï¡£µ±È»£¬Èç¹ûÖ»ÊÇÊý¾ÝºÏ²¢£¬ÔòʹÓÃADO¾Í¿ÉÒÔʵÏÖ£¬µ«Èç¹ûÒª±£Áô±í¸ñ¸ñʽ£¬Ôò¿ÖÅÂÖ»ÄÜʹÓð³µÄ·½·¨ÁË¡£
Ò»¡¢º¯Êý´úÂ룺
Option Explicit
'* ********************************************************* ......
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn.Open "Provider=OraOLEDB.Oracle.1;Persist Security Info= ......
ÌâÄ¿£ºÒ»¼ÒСÐͺ½¿Õ¹«Ë¾¸Õ¸Õ¹ºÂòÁËһ̨¼ÆËã»ú£¬ÒÔʹÓÃеĻúƱ×Ô¶¯Ô¤¶©ÏµÍ³£¬Õâ¼Ò¹«Ë¾ÒªÇóÎÒÃÇ¿ª·¢Õâ¸öÐÂϵͳ¡£ÎÒÃÇÐèÒª±àдһ¸öÓ¦ÓóÌÐò£¬¶ÔÕâ¼Òº½¿Õ¹«Ë¾Î¨Ò»µÄÒ»¼Ü·É»ú£¨ÈÝÁ¿Îª10¸ö×ù룩µÄÿ¸öº½°à·ÖÅä×ùλ¡£Õâ¸öÓ¦ÓóÌÐòÓ¦¸ÃÊäÈëÏÂÃæÕâЩѡÏÇëÊäÈë1Ñ¡ÔñÍ·µÈ²ÕºÍÇëÊäÈë2Ñ¡Ôñ¾¼Ã²Õ¡£Èç¹ûÓû§ÊäÈë1£¬Ó¦ÓóÌÐòÓ¦¸Ã·ÖÅäÒ ......