带参数的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+ '% ' "
