我利用VB.NET+access实现模糊查询
SQL语句为slt="select * from sheet1 where name like ' * "& textbox1.text &" * ' "
例如我在TEXTBOX1里写如 '王'
得到语句为: select * from sheet1 where name like ' * 王* '
然后是没有找到任何一条信息
但是我把这条信息直接写到ACCESS里的查询中,就能找到!
那位高手指点一下,错在哪里?

[此贴子已经被作者于2006-5-25 12:15:04编辑过]

slt="select * from sheet1 where name like ' % " & textbox1.text.trim &" %' "

还是不行：斑竹看看其他代码有什么问题？
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connstr, slt As String
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\db1.mdb"
slt = "select * from sheet1 where name like ' % " & TextBox1.Text.Trim & " %' "
Dim ad As New OleDbDataAdapter, ds As New DataSet, conn As New OleDbConnection
conn = New OleDbConnection(connstr)
conn.Open()
ad = New OleDbDataAdapter(slt, conn)
ad.Fill(ds, "sheet1")
DataGrid1.DataSource = ds.Tables("sheet1")
conn.Close()
End Sub

slt = "select * from sheet1 where name like ' % " & TextBox1.Text.Trim & " %' "
去掉空格吧!
slt = "select * from sheet1 where name like '%" & TextBox1.Text.Trim & "%'"

我要和楼主好好交流  QQ:627792681   MSN:xcywinxp@

为什么要加星号呢？
slt="select * from sheet1 where name like' " & textbox1.text & " % '"
应该这么写吧！