Originally Posted by
rushy
wow, thanks, works a treat, however having a slight issue that i had more than one customer in the combo box, but the filtering seems to leave me with just the Customer that has been selected. Thanks again
You can modify the filter according to your needs.
It is basically the WHERE part of your SQL statement.
e.g.
Code:
dttblCustomer.DefaultView.RowFilter = "CustomerID=1 OR CustomerID=2 OR CustomerID=3"
If it would be getting too complex, then it is always better to fill your datatable with only rows of your interest from your database with appropriate SQL query.
icon on the left of the post. 
Reply With Quote