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

vb¶ÁÈ¡excelÊý¾ÝÈ¥µô¿ÕÐÐ - VB / ÍøÂç±à³Ì

¸÷λ´ó¸ç´ó½ãÃÇ£¬ÎÒÓöµ½Ò»¸öСÂé·³£¬ÔÚÍøÉÏÕÒÁ˺ܾÃҲûÓиöÈ·ÇеĴ𰸣¬¾ÍÏëÎÊÎÊ´ó¼Ò£¬ÎÒÓÃadodbÁ´½Óexcel£¬¶ÁÈ¡³öexcelµÄÊý¾Ý·ÅÔÚdatasetÀ°ÑdatasetµÄÖµÖ±½Ó°ó¶¨µ½´°ÌåÉϵÄdataGridÁË£¬µ«ÊÇexecelÉÏÃæÓÐÊý¾Ý£¬ÏÂÃæÓкܶà¿ÕµÄÐУ¬Ò»Æð¶Áµ½ÁËdataGridÉÏÁË£¬ÎÒÏëÎÊ£¬Ôõô°ÑÕâЩ¿ÕÐÐÔÚ³ÌÐòÀïÈ¥µô£¿

ºÜ¶à¿ÕÐÐÊDz»ÊÇÄãÇùý»Ø³µµÄ?



excelµÚÒ»ÁÐÊÇ¿ÉÒÔΪ¿ÕµÄ£¬Ó¦¸ÃÅжϵÚËÄÁÐD²»Îª¿Õ£¬µÚËÄÁÐÊDz»ÔÊÐíΪ¿ÕµÄ£¬·ñÔò¾ÍÊÇÕû¸öÐж¼Êǿյ쬵ÚËÄÁÐÔõô±íʾ£¿ÎÒ¶ÔvbÁ˽âÌ«ÉÙ£¬Ï£ÍûÖ¸µãÖ¸µãÃÔ½ò°¡£¡

µÃµ½rsºó£¬±éÀúÇá¿Õ¿Õ¸ñ£¬ÔÙ¸½¸ødatagrid

ÎÒ¾õµÃÊÇ¿ÉÒÔÔÚµ¼ÈëµÄʱºòдsqlÓï¾ä£¬¸ù¾ÝwhereÌõ¼þºóÃæµÄɸѡµÄ£¬µÚËÄÐÐÒªÔõÑù´úÌæ£¿Ïñ£º
Select * from [Sheet1$] where f1<>NULL
Èç¹ûÊÇÅжϵÚËÄÐÐÊÇ·ñΪ¿ÕÔõôдwhereºóÃæµÄ


ÓÃÕâ¸ö xlExcel.ActiveSheet.UsedRange.Rows.Count È·¶¨EXCEL±í¸ñÖÐÊý¾ÝµÄÐÐÊý¡£

ÒýÓÃ

ÎÒ¾õµÃÊÇ¿ÉÒÔÔÚµ¼ÈëµÄʱºòдsqlÓï¾ä£¬¸ù¾ÝwhereÌõ¼þºóÃæµÄɸѡµÄ£¬µÚËÄÐÐÒªÔõÑù´úÌæ£¿Ïñ£º
Select * from [Sheet1$] where f1<>NULL
Èç¹ûÊÇÅжϵÚËÄÐÐÊÇ·ñΪ¿ÕÔõôдwhereºóÃæµÄ


f4<>NULL

f1 f2 f3 ...fNÄãÓжàÉÙÁÐN


°ïæ¶¥Ò»ÏÂà¶

ÕâÑùд»áÓдíÎóµÄ£ºSELECT * from [Sheet1$] where f4<>NULL ´íÎó£ºÊý¾Ýµ¼Èëʧ°Ü£¬ÖÁÉÙÓÐÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ¡£Ôõô»ØÊ£¿

½â¾öÁË£¬ºÇºÇ£¬Ð»Ð»´ó¼Ò£¡Ã¿¸öÈ˶¼·Öµã·Ö°É£¡


Ïà¹ØÎÊ´ð£º

vb ÖÐ - VB / »ù´¡Àà

ÏÖÔÚÎÒÏë¸ù¾ÝtreeviewÉÏÿ¸ö½ÚµãµÄȨÏÞ£¬Ã»ÓÐȨÏ޵Ľڵ㲻Äܱ»Ñ¡ÖУ¬¶øÇҳɻÒÉ«£¬ÔõôʵÏÖ£¬ÔÚÏߵȡ£¡£¡£
Õâ¸ö£¿¡£¡£¡£
Ã²ËÆÃ»·¨¡£
ÊÔÊÔÄܲ»ÄܸÄijЩnodeµÄÑÕÉ«£¬¼Ç¼ÏÂÉϴεÄnodeclickÀïµÄnode¡£
Ï´εã»÷µÄÈç¹ ......

vb - VB / »ù´¡Àà

ÎÒÏë°ÑwordÁí´æÎªxmlÖ®ºó£¬ÓÃvb¶ÁÈ¡Õâ¸öxmlµÄÄÚÈÝ£¬ÇëÎÊÈçºÎʵÏÖ£¿
dim f as integer
dim b() as byte
dim s as string
dim L as long
f=freefile()
open "abc.xml" for binary access read as #f
......

vb - VB / »ù´¡Àà

vbÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»»
Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......

vb - VB / »ù´¡Àà

xmlDoc1.loadXML(h)×ÜÊÇ·µ»Øfalse£¬ÎªÊ²Ã´£¿Ð»Ð»°ïæ»Ø´ðÒ»ÏÂ
hÊÇÊ²Ã´ÄØ¡£¡£¡£¡£¡£¡£¡£¡£¡£

hÊÇxml¸ñʽµÄ×Ö·û´®

ÄãÊÇÏë´ò¿ª¡£XML¸ñʽµÄÎļþ°É£¿

ÎÒÊǰÑh·ÅÔÚxmlDoc1ÀÓÃxmlDoc1.loadXML(h)£¬È»ºóÈ¡xmlDo ......

VBÏÂOCX¿É·ñʵÏÖÈçϹ¦ÄÜ£¿ - VB / ÍøÂç±à³Ì

ÎÒÏëÓÃVB×öÒ»¸öOCX£¨´¿²ËÄñ£¬ÁÙʱÐèÒªÓÃVB×öµã¶«Î÷£¬ÌØÀ´Çë½Ì£©£¬AÓû§£¨IP£º192.168.0.1£©ÓëBÓû§£¨IP£º192.168.0.2£©½øÐеã¶ÔµãµÄ·¢ËͽÓÊÕÏûÏ¢
ÒªÇó²ÉÓÃOCX·½Ê½£¬±ÈÈçAÓû§ÖªµÀBÓû§IP£¬ÎÒÖ±½Ó´«²Î£¨BµÄIP£©ÖÁOCX ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ