Hello people!

I need to filter the content of an employees table to be displayed on a combobox from the selection of an employer combobox. In other words, the employer combobox gives me the employer id, and I need only the employees that correspond to that employer to displayed. How can I achive that?




MAKO - "El super simio"

__________________
MAKO - \"El super simio\"

It seems you have read-in both the Employers table and the Employees table in DataTable objects and wish to filter the Employees table based on the Employer ID from the Employers table the user selects. You can do this easily by creting a DataView object based on the Employees DataTable like this.

Now suppose the Employer ID has changed and you wish to filter employees based on it. Assume that the Employer ID is numeric. You would do it like this:

This would filter the employeeView DataView so that it would contain only those employees whose id is equal to employerID.

If you've bound a control, a DataGrid or ComboBox for example, to the employeeView, the control would auto-update itself to reflect whatever data is contained in the employeeView. In other words, the bound control would contain the filtered employees (because the DataView has been filtered).

I hope this helps.

ejan

Hi ejan, I tried your advise and it seems to work, but what happens if the employer id is a string? I wrote the code but I get an evaluation exception.

MAKO - "El super simio"

To filter a DataView using a column whose data type is string, you'd use code similiar to this:

// Retrieve id of employer.
string employerId = "007";

// Filter employees based on employer id.
employeeView.RowFilter = "'" + employerId + "'";

By the way, the DataView.RowFilter property can be set to almost any valid SQL WHERE clause without specifying the WHERE keyword.

ejan

Sorry, a little mistake. The second line of code should read like this:

// Filter employees based on employer id.
employeeView.RowFilter = "EmployerId = '" + employerId + "'";

Cheers.


ejan