Question

请问用下面的代码在datagridview中为什么显示不了数据？

double max_area = Convert.ToDouble(this.textBox5.Text) + Convert.ToDouble(this.textBox5.Text) * 0.1;
double min_area = Convert.ToDouble(this.textBox5.Text) - Convert.ToDouble(this.textBox5.Text) * 0.1;
double max_money = Convert.ToDouble(this.textBox6.Text) + Convert.ToDouble(this.textBox6.Text) * 0.1;
double min_money = Convert.ToDouble(this.textBox6.Text) - Convert.ToDouble(this.textBox6.Text) * 0.1;

string sqlStr = "select [* from Houses where (Hmoney between '" + min_money + "' and '" + max_money + "') and (Harea between '" + min_area + "' and '" + max_area + "')";
当只有一个between ...and的时候是有数据的，两个就没有了；将'" + min_money + "' 、 '" + max_money + "'、 '" + min_area + "' 、'" + max_area + "'改成数字也能显示
求高手指导啊！！~~~ 谢谢了
sql那句写错了*前面没有[
string sqlStr = "select * from Houses where (Hmoney between '" + min_money + "' and '" + max_money + "') and (Harea between '" + min_area + "' and '" + max_area + "')";

Answer 1

在你的sql语句中where后面括号与括号之间用的是and ，也就是说要同时满足两个条件，才能有数据出来，运行显示没有数据 就说明条件不满足呗！

Answer 2

你设断点在数据库执行这条语句，应该是没有数据吧。。。