带参数的access模糊查询怎么写啊？
Public Function GetProduct_Info(ByVal Name As String) As DataTable
conn.Open()
Access = "Select ID, ClassName, Name, AddTime, IsShow FROM Product where Name = @Name "
Adcmd = New OleDbDataAdapter(Access, conn)
Adcmd.SelectCommand.Parameters.Add( "@Name ", OleDbType.Char).Value = Name
Dim dt As New DataTable
Adcmd.Fill(dt)
conn.Close()
Return dt
End Function

怎么把where Name = @Name "改成模糊查询？

[解决办法]
Access = "SELECT ID, ClassName, Name, AddTime, IsShow FROM Product WHERE Name LIKE @Name "
[解决办法]
Access = "SELECT ID, ClassName, Name, AddTime, IsShow FROM Product WHERE Name LIKE '% ' + @Name + '% '

或者

Access = "SELECT ID, ClassName, Name, AddTime, IsShow FROM Product WHERE Name LIKE '% ' + ? + '% '

没装Access ,试试

我怎么记得Access的参数化查询是?,不是SQL 里面的@ + 参数名


[解决办法]
like '% '+@Name+ '% ' "