thieumao

Kết nối database Access với VB6

Oct 20th, 2013
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 1.46 KB | None | 0 0
  1. Private Sub cmdDung_Click()
  2.     Unload Me
  3. End Sub
  4.  
  5. Private Sub cmdTiep_Click()
  6.     Dim Cn  As ADODB.Connection
  7.     Dim Rs  As ADODB.Recordset
  8.     Dim strSQL As String
  9.     Dim bHople As Boolean
  10.     'Khoi tao moi mot doi tuong Connection
  11.     Set Cn = New ADODB.Connection
  12.     Cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;  Data Source = QUANLYNGUOIDUNG2.MDB"
  13.     'Cn.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source = QUANLYNGUOIDUNG.mdb"
  14.     Cn.Open
  15.     'Thuc thi cau lenh SQL de lay tat ca Ten va Matkhau co trong CSDL
  16.     strSQL = "Select TEN, MATKHAU from NGUOIDUNG"
  17.     Set Rs = New ADODB.Recordset
  18.     Rs.Open strSQL, Cn, adOpenStatic, adLockOptimistic
  19.     'Kiem tra xem du lieu doc ra co hop le khong
  20.     If (Rs.BOF = True) Then
  21.     MsgBox "Khong doc duoc thong tin nguoi dung trong co so du lieu"
  22.     Rs.Close
  23.     Cn.Close
  24.     Exit Sub
  25.     End If
  26.     Rs.MoveFirst
  27.     bHople = False
  28.     'Lan luot Tim kiem xem username va password co ton tai trong CSDL khong
  29.     Do While ((Not Rs.EOF) And (Not bHople = True))
  30.         If (Rs![TEN] = txtUsername.Text And Rs![MATKHAU] = txtPassword.Text) Then
  31.             bHople = True
  32.         Else
  33.             Rs.MoveNext
  34.         End If
  35.     Loop
  36.     'Dong ket noi voi CSDL
  37.     Rs.Close
  38.     Cn.Close
  39.     If (bHople = True) Then
  40.         MsgBox "Chuc mung ban da su dung chuong trinh"
  41.         Unload Me
  42.     Else
  43.         MsgBox "Username hay Password khong hop le"
  44.     End If
  45. End Sub
Advertisement
Add Comment
Please, Sign In to add comment