Search in DataGridView using 3 text

May 18 2020 12:13 PM
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.