vb.net - Searching button doesn't work when i click

Question

when I type "Sang" in textbox , the table doesn't show the Judul Buku with "Sang" word in the table.

This is the code in Search button :

Private Sub TsSearch_Click(sender As Object, e As EventArgs) Handles TsSearch.Click
    If TxtKeyword.Text <> "" Then
        TBL_BukuTableAdapter.FillByJudulBuku(UASDataSet.TBL_Buku, TxtKeyword.Text)
    End If
End Sub

I also add the Search Button in the Query..

question from:https://stackoverflow.com/questions/65859361/searching-button-doesnt-work-when-i-click

Answer 1

You have one too many @ symbols in your WHERE clause

WHERE (@Judul_buku LIKE '%' + @Judul_buku + '%')

With this statement, you are comparing the parameter with itself, this will always be true, therefore all of the rows in the table will be returned.

You should remove the first @ symbol to refer to the column and not the parameter, like:

WHERE (Judul_buku LIKE '%' + @Judul_buku + '%')