ÔÚvb6.0ÖÐ
mshflexgrid¿Ø¼þÀïÓÐNÌõ¼Í¼£¬
RT:
ÐòºÅ ÁϺŠÊýÁ¿ ×é
1 123455 1.2000 01
2 343585 1.0003 05
3 351351 2.0000 06
4 687486 3.0000 07
5 988754 4.0000 07
6 874845 2.2222 09
....
È«²¿µÄÁϺŶ¼²»ÏàÍ ......
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£¬¼ÓÔØºÜ¶à¿Ø¼þ£¬ÔÙ¿½±´Êý¾Ý¿âͼƬµÈµÈ¡£
Ï£Íû´ó¼Ò¸øÓëÒâ¼û£¬»á¾¡¿ì½áÌù¸ø·Ö¡£
......