I'm using a binding source on a Windows Form application and I'm trying to filter the data using the "Filter" property on the binding source. I can't get the filter to work when doing Scalar queries (i.e. SUM(), AVG(), COUNT() etc.). Here is the basic flow of the code that I have.
//apply filter to inventory datasource
bindingSource.Filter = filterString;
OnHandQuantity = Convert.ToDouble(tableAdapter.SumOfInventory(productCode));