Hi Glen,
DataView's RowFilter property does work with int fields in SQL Server. Can you provide your code of how you are setting the RowFilter? Here is an example:
dv.RowFilter = "ProductID > 40"
>To All:
>We are trying to understand rowfilters. We are working with a SQLServer Database. When setting the rowfilter on a Character field it works. When setting it to an Int field there are never any results. No errors, no results. Same database, same table, same piece of code, different field. We can physically see what the results should be, but we don't get anything.
> We would greatly appreciate a hint at what the problem might be.
>
> Thanks in advance.
>
>Regards,
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi