Using Filter and Find method of bindingsource

[gurusshetty]

Hi

How to use filter or find on more than one column in C#.Net 2005.

e.g. I have a purchase table which contains column like date of purchase, supplier name, raw material and qty of purchase. I wants to view records of purchase made from a particular supplier for a particular date. So I am filtering purchase table on two fields i.e. date of purchase and supplier name but it is not working. It is giving me an error message "Syntax error: Missing operand before '&' operator. I am using following line of code in my project.

purchaseBindingSource.Filter = "date = '" + Convert.ToDateTime(dtPurchase.Text) + "' && supplier = '" + cmbSupplierName.Text + "'";

similarly how to use find method of bindingsource for more than one column.

regards,

guru shetty