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

VB´úÂëÁ´½ÓSQL2005ÎÊÌ⣬Çó½â

Public Class Form1

  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

  MsgBox(1)

  Dim Cnn As New ADODB.Connection '¶¨ÒåÊý¾ÝÁ´½Ó¶ÔÏó £¬±£´æÁ¬½ÓÊý¾Ý¿âÐÅÏ¢£»ÇëÏÈÌí¼ÓADOÒýÓÃ

  MsgBox(2)
  Dim Rs As New ADODB.Recordset '¶¨Òå¼Ç¼¼¯¶ÔÏ󣬱£´æÊý¾Ý±í

  MsgBox(3)
  Dim strCnn = "Provider=SQLOLEDB.1;Initial Catalog=qzsyck ;Data Source=·þÎñ´óÖÚ;User ID=;Password=;Integrated Security=True;Persist Security Info=False;"

  MsgBox(4)
  Cnn.Open(strCnn)

  MsgBox("Á´½Ó³É¹¦")

  Rs.Open("select * from userpw", Cnn) '¶¨ÒåSQL²éѯÃüÁî×Ö·û´®

  MsgBox(6)

  End Sub
End Class


ÒÔÉÏÄËÎҵĴúÂ룬VBÁ´½ÓSQL2005£¬µ«ÊÇÔËÐе½Cnn.Open(strCnn)ÕâÐÐʱ¾Í±¨´í
  -------¶à²½ OLE DB ²Ù×÷²úÉú´íÎó¡£Èç¹û¿ÉÄÜ£¬Çë¼ì²éÿ¸ö OLE DB ״ֵ̬¡£Ã»Óй¤×÷±»Íê³É¡£

¸ÃÈçºÎµ÷ÊÔ£¿ÊÇ´úÂëµÄÎÊÌ⻹ÊÇÊý¾Ý¿âµÄÎÊÌ⣿ÎÒÊÇÔ¶³ÌÁ´½ÓÊý¾Ý¿âµÄ£¬»¹ÓУ¬ÎÒÒѾ­Ìí¼ÓÒýÓÃÁË
Microsoft ADO Data Control
Microsoft DataGrid Control

Dim strCnn = "Provider=SQLOLEDB.1;Initial Catalog=qzsyck ;Data Source=·þÎñ´óÖÚ;User ID=SA;Password=SAµÄÃÜÂë;Integrated Security=True;Persist Security Info=False;"

Ò


Ïà¹ØÎÊ´ð£º

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

vb - VB / »ù´¡Àà

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

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

dim a as string,b as string£¬c as string
a="¹¤³Ì±àºÅ,µ¥Î»¹¤³ÌÃû³Æ,·Ö²¿¹¤³Ì±àºÅ"
b="µ¥Î»¹¤³ÌÃû³Æ"
c="µ¥Î»"
Ôõô²ÅÄÜÅжϳöa×Ö·û´®ÖдæÔÚb×Ö·û´®£¬¶ø²»´æÔÚc×Ö·û´®

¿´¿´i ......

vb²Ù×÷excel - VB / »ù´¡Àà

ÎÊÌ⣺
ÏÖÔÚAccessÊý¾Ý¿âÖÐÓÐÁ½ÕűíTableAºÍTableB
TableAÖÐÓмǼÈçÏÂ:
×Ö¶Î1(Name) ×Ö¶Î2(Num)
  A 3
  A 4
  B 6
  ... ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ