Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- command.Parameters.AddWithValue("@searchTerm", searchTerm);
- command.CommandText = "SELECT [OA_Name] FROM [Operating_Authority_Table] WHERE [OA_Name] = [@%searchTerm%]";
- command.Parameters.AddWithValue("@searchTerm", searchTerm);
- command.CommandText = "SELECT [OA_Name] FROM [Operating_Authority_Table] WHERE [OA_Name] = '%' + @searchTerm + '%'";
- command.CommandText = "SELECT [OA_Name] FROM [Operating_Authority_Table] WHERE [OA_Name] LIKE '%"+ searchTerm +"%'";
- "...WHERE [OA_Name] = '%' + @searchTerm + '%'";
- "...WHERE [OA_Name] ALIKE '%' + @searchTerm + '%'";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement