level 1
甜腻紫罗兰🌿
楼主
If searchStr <> "" Then '当文本框内容不为空
objComm.CommandText = " Select*from PriceData where 商品名=" & "'" & searchStr & "'"
objComm.CommandText = "SELECT * FROM PriceData where [录入时间] between " & "#" & DateTimePicker2.Value & "#" & " and " & "#" & DateTimePicker3.Value & "#"
Else
MsgBox("当前查找内容为空！", MsgBoxStyle.OkOnly, "提示！")
End If
两个commandText怎么合并查询，小白求教
2017年10月20日 10点10分
1
objComm.CommandText = " Select*from PriceData where 商品名=" & "'" & searchStr & "'"
objComm.CommandText = "SELECT * FROM PriceData where [录入时间] between " & "#" & DateTimePicker2.Value & "#" & " and " & "#" & DateTimePicker3.Value & "#"
Else
MsgBox("当前查找内容为空！", MsgBoxStyle.OkOnly, "提示！")
End If
两个commandText怎么合并查询，小白求教