Dim sql As String
sql = "select * from 会员消费记录查询 where "
sql = sql + "消费日期 between '" + DropDownList3.SelectedValue + "'年 '" + DropDownList4.SelectedValue + "月1日" And "'" + DropDownList3.SelectedValue + "'年 '" + DropDownList4.SelectedValue + "月30日 "
SqlDataSource1.SelectCommand = sql
sql = "select * from 会员消费记录查询 where "
sql = sql + "消费日期 between '" + DropDownList3.SelectedValue + "'年 '" + DropDownList4.SelectedValue + "月1日" And "'" + DropDownList3.SelectedValue + "'年 '" + DropDownList4.SelectedValue + "月30日 "
SqlDataSource1.SelectCommand = sql
如果不是,拼接成yyyy-MM-dd这样的格式再试试
Dim time2 As String
time1=DropDownList3.SelectedValue+"-"+DropDownList4.SelectedValue+"-1"
time2=DropDownList3.SelectedValue+"-"+DropDownList4.SelectedValue+"-30"
然后 between '"+time1+"' And '"+time2+"' 这样写 好看一点吧
这样可以吗?