我想做的效果是,dategrid的表格中有好几个字段,然后有个添加过滤的按钮,点击按钮后,能自动添加一个对第一个字段的查询
字段一 条件(or,and,like) 值
字段二 条件(or,and,like) 值
字段三 条件(or,and,like) 值
类似这种,现在想问这个按钮的程序代码怎么写?具体写一个字段的查询我会。。。当时要智能删减查询。。。就。。……
[/Quote]
判斷一下你選擇的條件就可以了
select case trim(combox1.text).ToUpper
case "OR"
strSQL="select * from Table1 Where 1=1 or Field1=1 "
case "AND"
strSQL="select * from Table1 Where 1=1 and Field1=1 "
case "LIKE"
strSQL="select * from Table1 Where 1=1 and Field1='1%'"
end Select
[Quote=引用 1 楼 yangpeng785412 的回复:]
Dim chaxun As String = "select * from tushu where leibiedaima='2'"
Dim command As New SqlCommand(chaxun, conn)
conn.Open()
command.CommandType = CommandType.Text
command.Connection = con……
[/Quote]
呵呵,你根本没看我的提问么?你这样是针对某个具体字段查询。。我是想要可以自定义的效果。
Dim chaxun As String = "select * from tushu where leibiedaima='2'"
Dim command As New SqlCommand(chaxun, conn)
conn.Open()
command.CommandType = CommandType.Text
command.Connection = conn
Dim dr As New SqlDataAdapter
dr.SelectCommand = command
Dim ds As New DataSet
ds = New DataSet("ds")
dr.Fill(ds, "tushu")
DataGridView1.DataSource = ds
DataGridView1.DataMember = "tushu"