sql search

Question

I pulled the data using user control but I want to search within the data how can I do

  Dim myconnection As New SQLiteConnection("Data Source=" & Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) & "\\Data" & "\data.db;Version=3")  
            myconnection.Open()  
            Dim sda As SQLiteDataAdapter  
            Dim cmd As New SQLiteCommand  
            cmd.Connection = myconnection  
            cmd.CommandText = "Select * from krp"  
            Dim rdr As SQLite.SQLiteDataReader = cmd.ExecuteReader  
            Dim dt As New DataTable  
            dt.Load(rdr)  
            rdr.Close()  
            myconnection.Close()  
  
            cmd.CommandText = <sql>SELECT * FROM krp   
                   WHERE [site] LIKE @site </sql>  
            cmd.Parameters.Add("@site", DbType.AnsiString).Value = $"%{GunaLineTextBox2.Text}%"  
            sda = New SQLiteDataAdapter(cmd)  
            sda.Fill(dt)  

Answer 1

Make sure to consider case insensitive on the where.

• See How to Make SQLite’s LIKE Operator Case-Sensitive
• Also make sure to set Option Strict On in the class or form this code resides as I noticed you don't and that can cause issues