I am using this code in C# as shown below, to view the students first name.
studentsBindingSource.filter = "[First Name] like '%" + txtFirstName.text + "%'";
This code is very useful and working well.
If i input at a textbox for example, a letter [M] or abbreviations, all the students with letter M will be displayed, so no problem with that.
But how about if i input an abbreviated name with spaces for example [M a] or [A u], [Ad Us], etc., that displays a two word name for having it specific. For this example a named with "M a" will be displayed like "Mary Ann", Mark Andrew and so on.
So i need help to solve this problem, coz i'm having trouble for this, coz everytime i use an abbreviation that uses spaces resulted to a no display data grid view.