几个小问题希望各位大哥可以帮小弟解释下
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
[解决办法]
