I made a form with a DataGrid control (that's bound to my Customer Table) and it works fine.
What I want to do now is sorting every columns in that DataGrid or let users type something in a TextBox in order to search for a record (that matches of course).
To do that, I put as many textbox as columns.
Example
TextBox
Code [] Name[] City[]
DataGrid
Code Name City
0001 Arnaud Paris
0002 Tom Madrid
If the Code_TextBox got the focus, I want the DataGrid being sorted by code.
If user type something in the Name_TextBox, I want the DataGrid being sorted by Name and the cursor reposition to the first record that matches in the DataGrid.
Any idea ?!?
