arezz09 -2 Junior Poster in Training

how to make search button for datagrid that can search by any thing that i hve set..for example smething like this but i use this code for listview

IsConnected("Select * from manager_table Where firstname like '" & Me.TextBox1.Text & _
                        "%' or status like '" & Me.TextBox1.Text & "%' or lastname like '" & Me.TextBox1.Text & "%' or gender like '" & Me.TextBox1.Text & "%' or address like '" & Me.TextBox1.Text & "%';", False)
        Call Loader()