If Requery2 <>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery2 <>"" And Requery3<>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery2 <>"" And Requery4<>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery2 <>"" And Requery3<>"" And Requery4<>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery3 <>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList2 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery3 <>"" And Requery4<>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery4 <>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 产品1 like '%"& Requery4 &"%' "& DropList2 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery6 <>"" Then
StrSelect ="Select top 50 * from sc2001 Where 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery2<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery2<>"" And Requery3<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery2<>"" And Requery3<>"" And Requery4<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery2<>"" And Requery3<>"" And Requery4<>"" And Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery2 <>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList1 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery2 <>"" And Requery3<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery2<>"" And Requery3<>"" And Requery4<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery2<>"" And Requery3<>"" And Requery4<>"" And Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery3<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery3<>"" And Requery4<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery3<>"" And Requery4<>"" And Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery4<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery4<>"" And Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 ="" and Requery2="" and Requery3="" and Requery4 ="" and Requery5="" and Requery6 =""then
str="<br><br><br><center>"
str+="<font size=2>您没有输入查询条件,请输入查询条件!<a href='javascript:history.go(-1)'>按此返回</a></font>"
str+="</center>"
Response.Write(str)
Response.End
End If
Dim MySqlConnection As SqlConnection
Dim Ds As DataSet
Dim myCommand As SqlDataAdapter
mySqlConnection = New SqlConnection(ConfigurationSettings.AppSettings().Item("ConnectionString"))
MySqlConnection.Open()
myCommand = new SqlDataAdapter(StrSelect,mySqlConnection)
Ds = New DataSet()
myCommand.Fill(Ds,"sc2001")
myDataGrid.DataSource = Ds.Tables("sc2001").DefaultView
MyDataGrid.DataBind()
End Sub
巨长呀。。谁来优化一下!
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery2 <>"" And Requery3<>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery2 <>"" And Requery4<>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery2 <>"" And Requery3<>"" And Requery4<>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery3 <>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList2 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery3 <>"" And Requery4<>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery4 <>"" And Requery5<>"" then
StrSelect ="Select top 50 * from sc2001 where 产品1 like '%"& Requery4 &"%' "& DropList2 &" 产品2 like '%"& Requery5 &"%'"
End If
If Requery6 <>"" Then
StrSelect ="Select top 50 * from sc2001 Where 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery2<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery2<>"" And Requery3<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery2<>"" And Requery3<>"" And Requery4<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 <>"" And Requery2<>"" And Requery3<>"" And Requery4<>"" And Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 法人单位 like '%"& Requery1 &"%' "& DropList1 &" 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery2 <>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList1 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery2 <>"" And Requery3<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery2<>"" And Requery3<>"" And Requery4<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery2<>"" And Requery3<>"" And Requery4<>"" And Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 省地县码 like '%"& Requery2 &"%' "& DropList2 &" 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery3<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery3<>"" And Requery4<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery3<>"" And Requery4<>"" And Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 行业类别 like '%"& Requery3 &"%' "& DropList3 &" 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery4<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery4<>"" And Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 产品1 like '%"& Requery4 &"%' "& DropList4 &" 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery5<>"" And Requery6<>"" then
StrSelect ="Select top 50 * from sc2001 where 产品2 like '%"& Requery5 &"%' "& DropList5 &" 产品3 like '%"& Requery6 &"%'"
End If
If Requery1 ="" and Requery2="" and Requery3="" and Requery4 ="" and Requery5="" and Requery6 =""then
str="<br><br><br><center>"
str+="<font size=2>您没有输入查询条件,请输入查询条件!<a href='javascript:history.go(-1)'>按此返回</a></font>"
str+="</center>"
Response.Write(str)
Response.End
End If
Dim MySqlConnection As SqlConnection
Dim Ds As DataSet
Dim myCommand As SqlDataAdapter
mySqlConnection = New SqlConnection(ConfigurationSettings.AppSettings().Item("ConnectionString"))
MySqlConnection.Open()
myCommand = new SqlDataAdapter(StrSelect,mySqlConnection)
Ds = New DataSet()
myCommand.Fill(Ds,"sc2001")
myDataGrid.DataSource = Ds.Tables("sc2001").DefaultView
MyDataGrid.DataBind()
End Sub
巨长呀。。谁来优化一下!
解决方案 »
- 解决这些问题需要多少钱啊??
- 简单问题,请问,这两段代码在性能上有区别吗?
- asp.net 参数化sql语句错误,不能批量修改错误,,大家帮忙看看。。
- 为什么csdn的人气这么高?
- 在ASP.NET2.0 WEB页面如何按回车获得焦点
- frame src
- ASP.NET State Service是什么?How to use ASP.NET State Service ??
- 如何禁止.NET开发环境自动添加、修改、重排ASP.NET程序中的HTML代码?
- 大哥们,急啊! 怎么用树形结构控件....介绍篇文章也好!谢了
- 在用MVC模式做教务系统的时候出现问题
- 请问如何用ado.net取存储过程的return值
- 怎样在单击按钮时将一文本插入到文本控件中当前光标处?
有必要select出来*吗
只要把你要的字段select 出来就可以了
还有
like % 字段 % 重的钱一个%如果不是很必要就不要加
这样的sql不能通过该字段进行索引查找