几个小问题希望各位大哥可以帮小弟解释下
1、查询多个字段：
select id,OrderNumber,BuyerAccount,BuyerName,OrderAmout,CommodityMoney,Payment,OrderTime,Supplier,Logistics,OrderLogistics FROM OrderTable where OrderNumber like '%" + ASPxTextBox1.Text + "%' and OrderLogistics like '%" + ASPxComboBox1.Text + "%' and Logistics like '%" + ASPxComboBox2.Text + "%' and BuyFrom like '%" + ASPxComboBox3.Text + "%' and BuyerAccount like '%" + ASPxTextBox2.Text + "%'and BuyerName like '%" + ASPxTextBox3.Text + "%'and Supplier like '%" + ASPxComboBox8.Text+ "%' and huodaofukuan like '%" + ASPxComboBox6.Text + "%' and Payment like '%" + ASPxComboBox7.Text + "%' and OrderTime between '" + ASPxDateEdit1.Text + "' and '" + ASPxDateEdit2.Text + "' and Sphone like '%" + ASPxTextBox6.Text + "%' and Sname like '%" + ASPxTextBox7.Text + "%' and OrderLook IS null  

这失效 为什么呢？错在哪里呢？

2、怎样读取ASPxGridView里面Sum（订单数量*订单价格的总额）的值；


------解决方案--------------------
1 try一下，看语句似乎没什么问题，可能列名写错了吧。
2 不太清楚你的意思，订单数量和订单价格这些，无论是服务器方法还是客户端方法，应该都能获取到的。

N多like的查询，如果有50W数据，直接会导致sql服务器挂掉。
------解决方案--------------------
用或者or
------解决方案--------------------
下次学用string.format方法，你这联字符串的方法太难看了

------解决方案--------------------
首先你要说下这里出现什么问题吧，什么都不说怎么解决那，简单的失效会有很多种的，你把sql语句里面的between and放在最后试下
------解决方案--------------------
Like 最好这么写
select * from tb where xx like @parm;

parameters.add("@param","'%xx%'");
------解决方案--------------------
晕，写错了，应该是 parameters.add("@param","%xx%");
------解决方案--------------------
select id,OrderNumber,BuyerAccount,BuyerName,OrderAmout,CommodityMoney,Payment,OrderTime,Supplier,Logistics,OrderLogistics FROM OrderTable where OrderNumber like '%" + ASPxTextBox1.Text + "%' and OrderLogistics like '%" + ASPxComboBox1.Text + "%' and Logistics like '%" + ASPxComboBox2.Text + "%' and BuyFrom like '%" + ASPxComboBox3.Text + "%' and BuyerAccount like '%" + ASPxTextBox2.Text + "%'and BuyerName like '%" + ASPxTextBox3.Text + "%'and Supplier like '%" + ASPxComboBox8.Text+ "%' and huodaofukuan like '%" + ASPxComboBox6.Text + "%' and Payment like '%" + ASPxComboBox7.Text + "%' and OrderTime between '" + ASPxDateEdit1.Text + "' and '" + ASPxDateEdit2.Text + "' and Sphone like '%" + ASPxTextBox6.Text + "%' and Sname like '%" + ASPxTextBox7.Text + "%' and OrderLook IS null
------解决方案--------------------

探讨

select id,OrderNumber,BuyerAccount,BuyerName,OrderAmout,CommodityMoney,Payment,OrderTime,Supplier,Logistics,OrderLogistics FROM OrderTable where OrderNumber like '%" + ASPxTextBox1.Text + "%' and Orde……

------解决方案--------------------
string.format比较规范化，然后最好是用参数化语句
------解决方案--------------------

探讨

string.format比较规范化，然后最好是用参数化语句

------解决方案--------------------
要想看清楚每个参数的值，按照10,11楼那样做
------解决方案--------------------
你的between 跟哪个and连着呢？