注册 登录
编程论坛 VB.NET论坛

新手用VB编的对ACCESS表格查询程序为什么全部都会显示,求指导

ktsjack 发布于 2012-05-03 22:51, 839 次点击
程序修改了半天终于没错了,但是在 text里面输入信息  要查询表里与 描述 这个字段相符的那一行信息,结果点查询以后不是查到想要的那行,而是全部显示出来,这是怎么个情况
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim objConn As New OleDb.OleDbConnection
        Dim objDa As New OleDb.OleDbDataAdapter
        Dim objComm As New OleDb.OleDbCommand
        Dim objDs As New DataSet
        Dim WhereStr As String
        WhereStr = ""
If Trim(TxtMS.Text) <> "" Then
            WhereStr = " 描述 like " + Trim(TxtMS.Text)
        End If
        objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source" & "='E:\cx.mdb'"
         = "Select * From 表1 "
        If WhereStr <> "" Then
             = & " where " & "'" & WhereStr & "'"
        End If
        objComm.Connection = objConn
        objDa.SelectCommand = objComm
        objConn.Open()
        objDa.Fill(objDs, "表1")
        DataGridView1.DataSource = objDs.Tables("表1")
        objConn.Close()

    End Sub
3 回复
#2
不说也罢2012-05-04 12:27
和上次的问题属于同一个问题,看看 最终赋值的内容是什么
没用上“%”?  找本书看看SQL语句的语法
#3
ktsjack2012-05-04 22:49
回复 2楼 不说也罢
恩,我再去看看查询语句吧,一定要用 % 这个符号吗?
#4
haigecnpeng2012-05-27 20:52
%代表通配符,不用%的话不如直接用=
1