i have a datagridview (connect with SQL) in C# Windows form Application. i have 3 Columns. 1st Column Country, 2nd column for the name and 3rd column last name.
And I have 3 textbox: 1st Country, 2nd Name 3rd last name.
Now i want search in datagridview using 3 text. for example
Country Name Lastname
Tunisia Ali Chetoui
France Jon Claude
Tunisia Yasin Chikawi
Argentine lionel Messi
Tunisia Ali Korbi
if insert Tu in Country textbox, grid will automatically show me all Countries containing of Tu characters (First Filter)
Country Name Lastname
Tunisia Ali Chetoui
Tunisia Yasin Chikawi
Tunisia Ali Korbi
Second if insert Ali in name textbox , grid will automatically show me all names containing of Ali characters (second Filter)
Country Name Lastname
Tunisia Ali Chetoui
Tunisia Ali Korbi
Second if insert Ch in Lastname textbox , grid will automatically show me all Lastnames containing of Ch characters (3rd Filter)
Country Name Lastname
Tunisia Ali Chetoui
What will be expected solution for this.