注册 登录
编程论坛 ASP.NET技术论坛

[求助]搜索功能代码是这样吗?怎么改?

lsz3344 发布于 2007-04-16 12:18, 512 次点击

Try
Dim a As String
Dim c As String
Dim b As String
Dim str As String
Try
Select Case (lx.SelectedValue)
Case 0
b = "*"
Case 1
b = ""
Case 2
b = ""
Case 3
b = ""
End Select
c = zi.Text
If (b = "*") Then
DataBind()
Else
Session("sqlstr") = "select * from message1 where " + b + " like '%" + c + "%'"
DataBind()
End If
Catch ex As Exception

End Try


Catch ex As Exception

End Try

1 回复
#2
lsz33442007-04-16 12:19
我想做搜索SQL表里的一个分类的字段,比如类型字段里的“体育,新闻,娱乐。。。。。。”这里面的代码要怎么改啊?
还是还有更好的代码啊?
1