²ËÄñÇó°ïæ VBÓëSQL server - VB / »ù´¡Àà
ÎÒÊDzËÄñ£¬¸ÕѧVBºÍsqlserver£¬Âé·³ÓÐËÄܸúÎÒ½²Ò»ÏÂÔÚVB2008ÉÏÈçºÎ×ö¶ÔÊý¾Ý¿âµÄ²éѯ¡¢¸ü¸ÄÔõô×ö£¿ADO.NET ÎÒÁ˽âһЩ£¬Ö»»áÓÃDataGridView BindingSource BindingNavigator ÕâЩ¿Ø¼þÖ±½Óµ÷ÓÃÊý¾Ý¿â±í£¬¿ÉÊǸüÉîÈëµÄ£¬±ÈÈçÔÚǰ̨ÉÏÔö¼ÓÈô¸ÉTextBOX ¶ÔÓ¦Êý¾Ý¿âÌõÄ¿ ǰ̨Ìîд£¬¸ü¸Äµ½Êý¾Ý¿âÉÏ£¬ÕâÑù¸ÃÈçºÎ×ö£¿Ç°Ì¨ÓëÊý¾Ý¿âÈçºÎÁªÏµ ÔÀíÊÇʲô£¿ лл´ó¼ÒÁË¡£
¿É²»¿ÉÒÔ°ïÃ¦ÍÆ¼ö¼¸±¾ÊéÄØ ÎÒ¿´¹ýÁËVisual basic 2008 ´ÓÈëÃŵ½¾«Í¨ Michael Halvorson дµÄ µ«ÊÇÕâ·½ÃæµÄÄÚÈݺÜÉÙ¡£
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ÎÒÏë°Ñ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ÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»»
Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......
Ôõô°ÑÒÑÖªµÄÊý¾Ý±£´æ³ÉxmlÎļþ£¬ÏÖÔÚÒÑÖªµÄÊý¾ÝÊÇ
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o=& ......