[RESOLVED] Problem with SQL query and RowFilter

[Moff]

A guess just by looking at your code that the formatting is wrong forthe maximum and minimum on the line

view.RowFilter = String.Format("BattingAverage >= {0} AND BattingAverage <= {1}", minimum, maximum);

try

view.RowFilter = String.Format("BattingAverage >= {0} AND BattingAverage <= {1}", minimum.ToString(), maximum.ToString());

I solved it by using the following code, but I guess yours will work to.

view.RowFilter = String.Format(Culture.Info.InvariantCulture.Number Format,("BattingAverage >= {0} AND BattingAverage <= {1}"), minimum, maximum);