Option Explicit
Public conn As New ADODB.Connection
Public Rs As New ADODB.Recordset
'Public Cnt As Integer 'Õâ¸öCntÊÇÓÃÀ´±íʾÊý¾Ý¿âÊý¾Ý×ÜÁ¿µÄ£¬¶ÔÁ´½Ó¹ý³ÌÎÞ¹Ø
Public Sub connect()
'Á¬½ÓÊý¾Ý¿âµÄ´úÂë¶Î
Set conn = New ADODB.Connection
Set Rs = New ADODB.Recordset
&nb ......
Public a As String
Private Sub Command1_Click()
a = Text1.Text
End Sub
ÀýÈç text1ÖÐÊäÈë 127.0.0.1 xxx.xxx.xxx.xxx
Private Sub Form_Load()
Adodc1.ConnectionString = "provider=sqloledb; data source=xxx.xxx.xxx.xxx;initial catalog=student1;user id=sa;password=sa;"
A ......
Set cn = New ADODB.Connection
cn.Open "provider=Microsoft.jet.OLEDB.4.0;data source=" & App.Path & "\member.mdb"
Set rs = New ADODB.Recordset
rs.Open "select * from attendance1 where ѧºÅ like '" & Text9.Text & &q ......
1¡¢Ëæ»úÉú³É1-100µÄÊ®¸öÊý£¬²¢ÇÒ½«ËûÃÇ´òÓ¡³öÀ´¡£´úÂëÈçÏ£º
Private Sub Form_Click()
Dim a(10) As Integer
Dim i As Integer
For i = 0 To 9
a(i) = Int(100 * Rnd(i)) + 1
Print a(i)
Next i
End Sub
Õâ¸öʱºòÊä³öµÄ½á¹ûÊÇÕýÈ·µÄ£¬µ«ÊÇFor-NextʹÓÃDO-WHILEÀ´´úÌæµÄʱºò£¬Êä³öµÄÊ®¸öÊýÈ«² ......
ÔÚvbµÄÎļþ²Ëµ¥ÓÐÒ»¸öÉú³É.exeµÄ¹¦ÄÜ£¬µ«ÊÇÕâÑùÉú³ÉµÄ¿ÉÖ´ÐÐÎļþ±ØÐëÒªÇóʹÓÃÕß×°ÓÐvb£¬²¢ÇÒÔÙ¼ÓÔØËùÐèµÄ¿Ø¼þµÈµÈ£¬·Ç³£·±Ëö¡£
ÓÐûÓй¦ÄÜ¿ÉÒÔʵÏÖ¾ÍÏñƽʱÎÒÃǹºÂòºÍÏÂÔصÄÈí¼þ£¬Ö±½Óµã»÷°²×°°ü¾Í»á°ÑÐèÒªµÄ¶«Î÷È«²¿°²ºÃ¡£Òª²»Óû§»¹µÃ×°vb£¬¼ÓÔغܶà¿Ø¼þ£¬ÔÙ¿½±´Êý¾Ý¿âͼƬµÈµÈ¡£
Ï£Íû´ó¼Ò¸øÓëÒâ¼û£¬»á¾¡¿ì½áÌù¸ø·Ö¡£
......
ÎÒÓиö³ÌÐòÊÇÓÃVB±àµÄ,Ö»ÓпÉÖ´ÐгÌÐò1,ûÓÐÔ´´úÂë,ËùÒÔÖ»ÄÜÓÃVBÁíÍâÔÙ×öÒ»¸ö³ÌÐò2,ÏÖÔÚÎÒÏë°ÑÁíÍâµÄ³ÌÐò2×ö³ÉÒ»¸ö°´Å¥,ÎÒÏëʵÏÖµÄÊÇ:
ÔÚ´ò¿ªÔÓгÌÐò1µÄij¸öÒ³Ãæʱ,Ò»°´Õâ¸ö°´Å¥¾Í¿ÉÒÔ½«´ËÒ³ÃæµÄ±í¸ñ¿Ø¼þÀïµÄÄÚÈݵ¼Èëµ½EXCELÖÐ,
ÇëÎÊ´ó¼ÒÈçºÎʵÏÖ°¡?
Õâ¸öÄѶȱȽϴó£¬Ó¦¸Ã˵ÕâÑù×öЧ¹û²»¼Ñ¡£
ÓÑÇéUp.............
......