Private Sub XS_cx() '客户订单号的查询
Dim conn As New ADODB.Connection
Dim rs_find As New ADODB.Recordset
Dim connectionstring As String
connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\XS_xds.mdb"
conn.Open connectionstring
Dim Sql As String
Dim cx As String
cx = Trim("订单号")
If Text1.Text <> "" Then
Sql = cx & "=" & "'" & Trim(Text1.Text) & "'"
Else
Sql = ""
End If
If Sql <> "" Then
Sql = "select" & " " & cx & ",条码数据,日期" & " from 不良 where " & Sql
Else
Sql = "select" & " " & cx & ",条码数据,日期" & "from 不良"
End If
rs_find.CursorLocation = adUseClient
rs_find.Open Sql, conn, adOpenKeyset, adLockPessimistic
Set DataGrid1.DataSource = rs_find
DataGrid1.Columns(订单号).Caption = "订单号"
End Sub
上面是我通过订单号来查询的一段代码,可是我现在通过“订单号”字段里的前三位来查询。也就是只要符合订单号前三位的就符合条件。请高手指教 谢谢
Dim conn As New ADODB.Connection
Dim rs_find As New ADODB.Recordset
Dim connectionstring As String
connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\XS_xds.mdb"
conn.Open connectionstring
Dim Sql As String
Dim cx As String
cx = Trim("订单号")
If Text1.Text <> "" Then
Sql = cx & "=" & "'" & Trim(Text1.Text) & "'"
Else
Sql = ""
End If
If Sql <> "" Then
Sql = "select" & " " & cx & ",条码数据,日期" & " from 不良 where " & Sql
Else
Sql = "select" & " " & cx & ",条码数据,日期" & "from 不良"
End If
rs_find.CursorLocation = adUseClient
rs_find.Open Sql, conn, adOpenKeyset, adLockPessimistic
Set DataGrid1.DataSource = rs_find
DataGrid1.Columns(订单号).Caption = "订单号"
End Sub
上面是我通过订单号来查询的一段代码,可是我现在通过“订单号”字段里的前三位来查询。也就是只要符合订单号前三位的就符合条件。请高手指教 谢谢
解决方案 »
- 如何调用添加拼音功能
- VB或VB.net中如何调用DLL中的结构体参数
- 新手提问:关于如何使窗体自动适应图片大小的问题
- 已知三角形三边的长,求三个角的度数.(几何公式忘光了)
- 晕,用ado从access取出文字数据然后插入sql server,插入后出现全部是??的乱码.
- 用ADO能否实现每天建立一个数据库?数据库是ACCESS的
- 在VB中如何播放powerpoint文件?
- 关于打开读取文件
- [求助]请帮忙修改这个VB6.0对IPHLPAPI.DLL的相关操作[有分]
- 立即给分! vb6编译好的文件,从资源管理器中选择该文件,看文件属性,可以知道详细版本号。怎么用代码得出磁盘上的指定VB程序的版本号?
- VB6中Form.show中的Owner是什么类型?
- 美化VB开发的信息系统的窗体界面,跪求解决
Private Sub XS_cx() '客户订单号的查询
Dim conn As New ADODB.Connection
Dim rs_find As New ADODB.Recordset
Dim connectionstring As String
connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\XS_xds.mdb"
conn.Open connectionstring
Dim Sql As String
Dim cx As String
cx = Trim("订单号")
If Text1.Text <> "" Then
"select " & cx & ",条码数据,日期 from 不良 where Left(" & cx & ",3)='" & Trim(Text1.Text) & "'"
Else
Sql = "select" & " " & cx & ",条码数据,日期" & "from 不良"
End If
rs_find.CursorLocation = adUseClient
rs_find.Open Sql, conn, adOpenKeyset, adLockPessimistic
Set DataGrid1.DataSource = rs_find
DataGrid1.Columns(订单号).Caption = "订单号"
End Sub