Imports System.Data.SqlClient
Public Class Form1
Dim aconnection As SqlConnection
Dim acommand As SqlCommand
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim f As New Form2
Dim areader As SqlClient.SqlDataReader
Dim strsql As String
Dim str1, str2 As String
aconnection = New SqlConnection("data source=erpserver;initial catalog=DLCSYS;UID=sa;pwd=;")
strsql = "SELECT MA001,MA002 FROM DSCMA"
acommand = New SqlCommand(strsql, aconnection)
acommand.Connection.Open()
areader = acommand.ExecuteReader(CommandBehavior.CloseConnection)
With areader
Do While .Read = True
str1 = .GetString(0)
str2 = .GetString(1)
If Trim(TextBox1.Text) = Trim(str1) And Trim(TextBox2.Text) = Trim(str2) Then
MsgBox("恭喜您登录成功!")
Me.Visible = False
f.Show()
Else 行24 Trim(TextBox1.Text) <> Trim(str1) Or Trim(TextBox2.Text) <> Trim(str2) Then MsgBox("用户或密码错误!")
TextBox1.Text = ""
TextBox2.Text = ""
TextBox1.Focus()
End If
Loop
End With