Dim cn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Private Sub Command1_Click()
Dim txtSQL As String
Dim dd(3) As Boolean
Dim sMeg As String
Set cn = New ADODB.Connection
Set rst = New ADODB.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ssglbase;Data Source=虞毓-PC"
cn.Open
txtSQL = "select * from user_SS "
If Check1.Value Then
If Trim(txtdong.Text) = "" Then
sMeg = "栋号不能为空"
MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
txtdong.SetFocus
Exit Sub
Else
If Not IsNumeric(Trim(txtdong.Text)) Then
MsgBox "请输入栋号数字!", vbOKOnly + vbExclamation, "警告"
Exit Sub
txtdong.SetFocus
End If
dd(0) = True
txtSQL = txtSQL & "栋号 = '" & Val(Trim(txtdong.Text)) & "'"
End If
End If
If Check2.Value Then
If Trim(txtroom.Text) = "" Then
sMeg = "寝室号不能为空"
MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
txtroom.SetFocus
Exit Sub
Else
dd(1) = True
If dd(0) Then
txtSQL = txtSQL & "and 寝室号 = '" & Trim(txtroom.Text) & "'"
Else
txtSQL = txtSQL & "寝室号 = '" & Trim(txtroom.Text) & "'"
End If
End If
End If
If Check3.Value Then
If Trim(txtcollege.Text) = "" Then
sMeg = "学院不能为空"
MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
txtcollege.SetFocus
Exit Sub
Else
dd(2) = True
If dd(0) Or dd(1) Then
txtSQL = txtSQL & "and 学院= '" & Trim(txtcollege.Text) & "'"
Else
txtSQL = txtSQL & "学院= '" & Trim(txtcollege.Text) & "'"
End If
End If
End If
If Not (dd(0) Or dd(1) Or dd(2)) Then
MsgBox "请设置查询方式!", vbOKOnly + vbExclamation, "警告"
Exit Sub
End If
txtSQL = txtSQL & " order by 栋号,寝室号"
rst.CursorLocation = adUseClient
rst.Open txtSQL, cn, 1, 3
Set DataGrid1.DataSource = rst
rst.Close
End SubPrivate Sub Command2_Click()
Unload Me
frmMain.Show
End SubPrivate Sub Form_Unload(Cancel As Integer)
cn.Close
End Sub
提示: 实时错误‘-2147217900(80040e14)
第1行:’=‘附近有语法错误
Dim rst As New ADODB.Recordset
Private Sub Command1_Click()
Dim txtSQL As String
Dim dd(3) As Boolean
Dim sMeg As String
Set cn = New ADODB.Connection
Set rst = New ADODB.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ssglbase;Data Source=虞毓-PC"
cn.Open
txtSQL = "select * from user_SS "
If Check1.Value Then
If Trim(txtdong.Text) = "" Then
sMeg = "栋号不能为空"
MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
txtdong.SetFocus
Exit Sub
Else
If Not IsNumeric(Trim(txtdong.Text)) Then
MsgBox "请输入栋号数字!", vbOKOnly + vbExclamation, "警告"
Exit Sub
txtdong.SetFocus
End If
dd(0) = True
txtSQL = txtSQL & "栋号 = '" & Val(Trim(txtdong.Text)) & "'"
End If
End If
If Check2.Value Then
If Trim(txtroom.Text) = "" Then
sMeg = "寝室号不能为空"
MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
txtroom.SetFocus
Exit Sub
Else
dd(1) = True
If dd(0) Then
txtSQL = txtSQL & "and 寝室号 = '" & Trim(txtroom.Text) & "'"
Else
txtSQL = txtSQL & "寝室号 = '" & Trim(txtroom.Text) & "'"
End If
End If
End If
If Check3.Value Then
If Trim(txtcollege.Text) = "" Then
sMeg = "学院不能为空"
MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
txtcollege.SetFocus
Exit Sub
Else
dd(2) = True
If dd(0) Or dd(1) Then
txtSQL = txtSQL & "and 学院= '" & Trim(txtcollege.Text) & "'"
Else
txtSQL = txtSQL & "学院= '" & Trim(txtcollege.Text) & "'"
End If
End If
End If
If Not (dd(0) Or dd(1) Or dd(2)) Then
MsgBox "请设置查询方式!", vbOKOnly + vbExclamation, "警告"
Exit Sub
End If
txtSQL = txtSQL & " order by 栋号,寝室号"
rst.CursorLocation = adUseClient
rst.Open txtSQL, cn, 1, 3
Set DataGrid1.DataSource = rst
rst.Close
End SubPrivate Sub Command2_Click()
Unload Me
frmMain.Show
End SubPrivate Sub Form_Unload(Cancel As Integer)
cn.Close
End Sub
提示: 实时错误‘-2147217900(80040e14)
第1行:’=‘附近有语法错误
解决方案 »
- 怎样获取网页提交按钮的焦点
- ADO中Unique Table、Unique Schema、Unique Catalog三个动态属性怎么使???
- VB中如何实现Text控件的Undo功能?用API?
- 如何关闭ie窗口
- 在 vb中用web控件能显示asp网页么
- 幸运的人只有一个
- for 循环问题
- 在datagrid中我如何才能取得用户当前选择的是哪一条记录?
- 请问各位高手,学好VB最快的方法是什么?
- 为了爱,程序员兄弟帮忙呀!
- 怎样将.xls数据导入OLE容器内的Excel中?
- vb 实时错误424,Set conn = Server.CreateObject("ADODB.connection")
txtSQL = "select * from user_SS where "
的and,学院,寝室号 前面都加一个空格
谢谢各位的帮忙
这个程序还要把rst.Close删了才运行起来的,带过!