Member Avatar for Denni_Mwebia

Hi guys....longtime:) Am working on a movie rental system in VB.NET, but there's a problem. I want a situation whereby the user will have the privilege to search for desired records by typing a search string, then hitting the search button. The results should be shown on a datagridview. Here's my code:

Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click

        Dim MovieName As String

        If txtMovieNamesearch.Text = "" Then
            MessageBox.Show("You must enter the name of the movie you want to search!", "I-Spot Movies", MessageBoxButtons.OK, MessageBoxIcon.Error)

            txtMovieNamesearch.Focus()
        Else
            MovieName = "select * from Movies  WHERE (Movie Name='" & txtMovieNamesearch.Text & "')"
            MoviesTableAdapter.FillByMovieName(_I_Spot_MoviesDataSet.Movies)

        End If

    End Sub

When i type a search string in the textbox and then i hit the search button, all the records disappear :( please help!!

Edited by peter_budo because: Keep It Clear - Do wrap your programming code blocks within [code] ... [/code] tags
  • 3 Contributors
  • 3 Replies
  • 387 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by ohunwujolly
Member Avatar for debasisdas

is the data being stored is case sensitive ?

Better to use LIKE inplace of = for character search.

try something like this

"select * from Movies WHERE upper(Movie_Name) like %'" & upper(txtMovieNamesearch.Text) & "'%"
Edited by debasisdas because: n/a
Member Avatar for Denni_Mwebia

I've inserted the line of code, but the problem still persists...the datagridview does not show the filtered records. How do make it display the filtered records?

Member Avatar for ohunwujolly

check the DataSource of the DataGrid

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.