SqlException was unhandled - search sql db from textbox 2

[liamcan]

Hi,

Any help with this will be greatly appreciated. I am creating an issue tracking with issues and resolutions as the fields. "SqlException was unhandled - An expression of non-boolean type specified in a context where a condition is expected, near ','." is the error message. The coding I used is:
Dim text As String
text = txtSearch.Text
Dim ad As String = "Select * from Iss_Res where Issue, Resolution LIKE" & text
Dim cn As New SqlConnection(ConStr)
Dim cn2 As SqlCommand = New SqlCommand(ad, cn)
cn.Open()
Dim sqlReader As SqlDataReader = cn2.ExecuteReader()
ds = New DataSet
dv = New DataView

Thanks,
liamcan

 

[Andrzejek]

You have incomplete SQL:

    Dim text As String
    text = txtSearch.Text
    Dim ad As String = "Select * from Iss_Res where   Issue, Resolution LIKE" & text
[blue]
    Debug.Print(ad) [/blue][green]
    'What do you get in Immediste Window here?[/green]

    Dim cn As New SqlConnection(ConStr)
    Dim cn2 As SqlCommand = New SqlCommand(ad, cn)
    cn.Open()
    Dim sqlReader As SqlDataReader = cn2.ExecuteReader()
    ds = New DataSet
    dv = New DataView

Have fun.

---- Andy

 

[liamcan]

Thanks, Andy, for the reply. I added the 'Debug.Print(ad)line, but debugging still displayed the same message on the "Dim sqlReader As SqlDataReader = cn2.ExecuteReader() line.
This is my first attempt at using vb.net. Thanks again!

 

[Andrzejek]

I am new to .NET, too. But try to move your line where you open the connection:

[blue]
    cn.Open()[/blue]
    Dim cn As New SqlConnection(ConStr)
    Dim cn2 As SqlCommand = New SqlCommand(ad, cn)[green]
    'cn.Open()[/green]
    Dim sqlReader As SqlDataReader = cn2.ExecuteReader()
    ds = New DataSet
    dv = New DataView

Have fun.

---- Andy

 

[woyler]

It is your SQL structure;
try,

Dim ad As String = "Select * from Iss_Res where " & _
	"Issue LIKE '%" & Text & "%' OR Resolution LIKE '%" & Text & "%'"

 

[liamcan]

Thank you, woyler, that worked!