Createing the filter option in Employee Table

HI Every One

How to create the filter option in the employee table. for Ex i have 4 designations FieldOfficer / Manager / Field Executive. if i select any field in the designation column. the emplyees who are in under the Manager category have to be filtered.

http://msdn.microsoft.com/en-us/library/aa893981(AX.10).aspx

Go through above link …you will understand many things about filtering and Database Queries…

those classes mentioned in above link used to filter the datasources…i hope you find it…