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(订单数量*订单价格的总额)的值;
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(订单数量*订单价格的总额)的值;
解决方案 »
- 关于域名指向问题!
- [求助] 请教购物车中套餐的算法或思路(多种排列组合得到最优惠套餐价格)
- asp链接文件路径,直接打开文件,不弹出下载提示
- 分全给你了-GridView中时间显示问题!!!
- Ajax collapsiblepanelextender 折叠和展开问题
- 。net2005转换成2003DataGrid1消失
- 网站发布问题! 请达人解惑!
- asp:Menu是否可以在编译后生成自己要的布局,而不是它的Table
- 怎么用RegularExpressionValidator验证DataGrid中的数据?
- 提问一个初级问题。
- DataTable 某列插入图片
- 为什么调试asp.net程序时,IE会锁定?
2 不太清楚你的意思,订单数量和订单价格这些,无论是服务器方法还是客户端方法,应该都能获取到的。N多like的查询,如果有50W数据,直接会导致sql服务器挂掉。
select * from tb where xx like @parm;parameters.add("@param","'%xx%'");