Refer to Alexeder's code as belows 'SQL query based on the search text Dim DR As ResultSet = sql1.ExecQuery2("SELECT * FROM dt_Country WHERE name LIKE ? ORDER BY name ASC",Array As String("%" & SearchText & "%")) "ORDER BY name ASC" it can used only English, If I need to test my...
Refer to Alexeder's code as belows 'SQL query based on the search text Dim DR As ResultSet = sql1.ExecQuery2("SELECT * FROM dt_Country WHERE name LIKE ? ORDER BY name ASC",Array As String("%" & SearchText & "%")) "ORDER BY name ASC" it can used only English, If I need to test my...