Rowfilter with multiple textboxes

Question

I would like to use two different textboxes to filter information from a database to display baseball players average score. Example selecting 0,3 to 0,4, should display players with scores between these number.

Whats not working is the following code:

// Textboxes with input data(decimal values)

decimal minimum = Convert.ToDecimal(textBox2.Text);

// SQL query to perform the search from my database

view.RowFilter = "select * from Players where BattingAverage between '" + minimum + "and" + maximum + "'";

I get an error message reading: Syntax error: missing operand after 'Players' operator.

Please help me.

// Mofflon

Vulpes · Answer

The DataView.RowFilter property uses special syntax rather than ordinary SQL. It's described in the MSDN docs for the DataColumn.Expression property which uses the same syntax: http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx So I'd try here: view.RowFilter = String.Format(BattingAverage >= {0} AND BattingAverage