系统加载时,限制了初始加载行数
现在想对日期取个月份值,现在的代码如下:
Dim nf As WinForm.ComboBox = e.Form.Controls("年份") '定义一个组合框控件,用来取日期的年份值
Dim cmd As New SQLCommand
Dim dt As DataTable
Dim cmb As WinForm.ComboBox
cmd.CommandText = "SELECT DISTINCT month(日期) as 月份 From {主表} "
dt = cmd.ExecuteReader()
cmb = e.Form.Controls("月份")
cmb.ComboList= dt.GetComboListString("月份")
这句代码可以通过后台取值,取到所有加载和未加载的"月份"的值
现在想实现:年份的组合框选定了年份后,在选月份的值时,能只加载年份组合框里选定的年份所对应的月份的值
我把sql代码改为: SELECT DISTINCT month(日期) as 月份 From {主表} where year(日期) = nf.text
但提示错误,请高手帮忙,谢谢!