Wildcard "%" not working

[MB]

Hi,
I am using a datagrid and the datagrid is filled through the SQL
query. The SQL query searches for the match in the database. The SQL
Query that i am writing is as follows

Dim selprod As String = "SELECT ProductID, ProductName FROM Products
WHERE ProductName LIKE '%prod%'"

but it is not working.
If I use the query this way(as given below) it works but I want to use
wildcard so that it searches thoroughly and provide with me with all
the records

Dim selprod As String = "SELECT ProductID, ProductName FROM Products
WHERE ProductName LIKE '" + prod + "'"

If i use LIKE '" +%prod%+ "'" or something sort of like this it doesnt
work either... any idea how it will work.

P.S My database is in SQL Server

Thanks in advance
MB

[Ken Tucker [MVP]]

Hi,

Dim strConn As String
Dim conn As SqlConnection

strConn = "Server = (local);"
strConn += "Database = NorthWind;"
strConn += "Integrated Security = SSPI;"

conn = New SqlConnection(strConn)

Dim cmd As SqlCommand
Dim strProduct As String = "chef"
Dim strSQL As String
strSQL = String.Format("Select * from Products Where Productname
LIKE '%{0}%'", strProduct)
cmd = New SqlCommand(strSQL, conn)

conn.Open()
Dim dr As SqlDataReader
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
Do While dr.Read
Console.WriteLine(dr.Item("productname"))
Loop
End Sub

Ken
----------------------
"MB" <ma******@yahoo.com> wrote in message
news:13**************************@posting.google.c om...

Hi,
I am using a datagrid and the datagrid is filled through the SQL
query. The SQL query searches for the match in the database. The SQL
Query that i am writing is as follows

Dim selprod As String = "SELECT ProductID, ProductName FROM Products
WHERE ProductName LIKE '%prod%'"

but it is not working.
If I use the query this way(as given below) it works but I want to use
wildcard so that it searches thoroughly and provide with me with all
the records

Dim selprod As String = "SELECT ProductID, ProductName FROM Products
WHERE ProductName LIKE '" + prod + "'"

If i use LIKE '" +%prod%+ "'" or something sort of like this it doesnt
work either... any idea how it will work.

P.S My database is in SQL Server

Thanks in advance
MB

[Herfried K. Wagner [MVP]]

* ma******@yahoo.com (MB) scripsit:

I am using a datagrid and the datagrid is filled through the SQL
query. The SQL query searches for the match in the database. The SQL
Query that i am writing is as follows

Dim selprod As String = "SELECT ProductID, ProductName FROM Products
WHERE ProductName LIKE '%prod%'"

but it is not working.
If I use the query this way(as given below) it works but I want to use
wildcard so that it searches thoroughly and provide with me with all
the records

Dim selprod As String = "SELECT ProductID, ProductName FROM Products
WHERE ProductName LIKE '" + prod + "'"

If i use LIKE '" +%prod%+ "'" or something sort of like this it doesnt
work either... any idea how it will work.

Your question is 0 percent related to VB.NET. Please post to the
appropriate group in future:

<URL:news://news.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<URL:http://msdn.microsoft.com/newsgroups/?dg=microsoft.public.dotnet.framework.adonet>

Thank you for your cooperation!

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>