sqlCon 数据库连接,用什么驱动都没写,是连ORACLE还是SQL SERVER ?
SELECT ADMID FROM ADMINFO WHERE ADMID='" + Me.TextBox1.Text.Trim() + "' AND ADMPWD='" + Me.TextBox2.Text.Trim() + "'"
Private Sub button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
If Me.TextBox1.Text.Trim() = String.Empty Then
MessageBox.Show("姓名不能为空")
Me.TextBox1.Focus()
ElseIf Me.TextBox2.Text.Trim() = String.Empty Then
MessageBox.Show("密码不能为空")
Me.TextBox2.Focus()
Else
Dim ds As New DataSet
Try
Dim sqlCon As New SqlConnection("Server=.;DataBase=CHEN;Uia=sa")
sqlCon.Open()
Dim sqlAda As New SqlDataAdapter("SELECT ADMID FROM ADMINFO WHERE ADMID='" + Me.TextBox1.Text.Trim() + "' AND ADMPWD='" + Me.TextBox2.Text.Trim() + "'", sqlCon)
' 以上这句SQL语句的意思是,从表ADMINFO中查找出ADMID为TextBox1中内容
' 并且ADMPWD为TextBox2中内容的记录
sqlAda.Fill(ds)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
If ds.Tables(0).Rows.Count = 0 Then
MessageBox.Show("用户名不存在或密码不正确")
Else
Me.Close()
End If
End If
End Sub
这是登陆的代码
Private Sub button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles button4.Click
Dim dt As New DataTable
If Me.TextBox1.Text.Trim() = String.Empty Then
MessageBox.Show("姓名不能为空")
Me.TextBox1.Focus()
ElseIf Me.TextBox2.Text.Trim() = String.Empty Then
MessageBox.Show("密码不能为空")
Me.TextBox2.Focus()
Else
Dim sqlCon As New SqlConnection
sqlCon.ConnectionString = "Data Source=WUFANG;Database=CHEN"
Dim sqlCmd As New SqlCommand
sqlCmd.Connection = sqlCon
sqlCmd.CommandText = "SELECT ADMID ADMINFO WHERE ADMID='" + Me.TextBox1.Text.Trim() + "' AND ADMPWD WHERE ADMPD='" + Me.TextBox2.Text.Trim() + "'"
Dim sqlAda As New SqlDataAdapter
sqlAda.SelectCommand = sqlCmd
Dim ds As New DataSet
Me.OleDbDataAdapter1.Fill(DataSet61)
Try
Me.OleDbConnection1.Open()
sqlCon.Open()
sqlAda.Fill(ds)
dt = ds.Tables(0)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Dim sql As String
Me.OleDbDataAdapter1.Fill(ds)
If dt.Rows.Count = 0 Then
MessageBox.Show("用户名不存在或密码不正确")
Me.TextBox1.Focus()
Else
Me.Close()
End If
End If
End Sub