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
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
string.format比较规范化，然后最好是用参数化语句
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
要想看清楚每个参数的值，按照10,11楼那样做
------解决方案--------------------------------------------------------
你的between 跟哪个and连着呢？