Filtering DataGrid

Hi,

I have developed a application on Pocket PC using c# CF 2.0.

I have binded a dataset to the datagrid. Say for example employee table which has EmpId, EmpName,Dept.

Now what I want to do is place 3 textbox on top of the grid and when the user enters data in empid then sort the grid and display all the employee's which starts with that entered data. Similar for other two textboxes.

For ex:

If emp table has below data

empid empname dept

00001 Smith Computer Science

01000 Rave Electronics

20000 John Electronics

When first time we bind the dataset with this grid we will show all the rows, but when say for example 0 is entered into first textbox for example say 0, then it should filter and show the below rows

empid empname dept

00001 Smith Computer Science

01000 Rave Electronics

Thanking all in advance,

Prashant

[919 byte] By [prashantmulay] at [2007-12-22]