Good Searching

 hello all..
i have make a searching, but is not good. my code like that:


Public Class getall 
Public Function getitem(ByVal id As String) As DataSet
        Dim con As SqlConnection = New SqlConnection("Data Source=BOYsqlexpress;Initial Catalog=GAMES;User ID=ha;Password=a")
        Dim ds As New DataSet()
 
        Dim adapter As New SqlDataAdapter("select * from [item] where name like '%" & id & "%'", con)
        Try
            con.Open()
            adapter.Fill(ds, "user")
            Return ds
        Catch ex As Exception
            Console.Write(ex.Message)

        Finally
            con.Close()
            con = Nothing
        End Try
        ' Next
        Return ds

    End Function
and class
 
 my item in database is containning
 dragon ball 3, counter strike
if i insert dragon, it can display dragon ball 3.
but if i insert dragon 3, it not display dragon ball 3.
it should display dragon ball 3 .
how should i change my code?
thx...