Dim UserName As String = e.Form.Controls("UserName").Value
Dim cmd As New SQ LCo mmand
Dim dt As DataTable
Dim dr As DataRow
Dim c1 As WinForm.ComboBox = e.Form.Controls("ComboBox1")
If c1.text="专用sql数据库,正式环境!"
cmd.Con ne ctio nNa me = "电子审批台账"
Else If c1.text="本地acc数据库,仅供练习!"
cmd.Co nnec tionN ame = "本地acc数据库"
End If
If UserName = "" Then
Messagebox.show("请选择用户!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information)
Return
End If
cmd.Comm andText = "Se lect * From {用户表} Where [警号] = '" & UserName & "'"
dt = cmd.ExecuteReader(True)
If dt.DataRows.Count = 0 Then
Messagebox.show("此用户不存在!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information)
Return
End If
dr = dt.DataRows(0)
If e.Form.Controls("PassWord").Value = dr("密码") Then
vars("警号") = UserName
vars("UserName") = dr("用户名称")
output.Show( vars("UserName") )
vars("类别") = dr("类别")
vars("所在单位") = dr("所在单位")
e.Form.Close
Else
Messagebox.show("密码错误!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information)
End If
怎么实现
If c1.text="专用sql数据库,正式环境!" 时数据连接sql数据库的表
cmd.Con ne ctio nNa me = "电子审批台账"
Else If c1.text="本地acc数据库,仅供练习!" 时数据连接本地ACC数据库的表
cmd.Co nnec tionN ame = "本地acc数据库"
End If