windows - 选择日期范围以使用 RowFilter 过滤 DGV

Question

我正在通过日期选择器控件获取日期，但没有取得任何成功，任何人都有任何建议。

我试过:

Dim fromDate As New DateTime(startdate_picker_search_supplierinvoice.Text)
Dim toDate As New DateTime(enddate_picker_search_supplierinvoice.Text)

query &= "supplier_invoice_date >= '" & fromDate & "' AND supplier_invoice_date <= '" & toDate & "'"
invoicesresults_datagrid_search_supplierinvoice.DataSource = SelectDataTable(dt, query)

错误:从字符串“Tuesday, July 17, 2012”到类型“Long”的转换无效。

Answer 1

不要使用返回完整写出日期的 .Text 属性。而是使用:

Dim fromDate As DateTime = startdate_picker_search_supplierinvoice.Value
Dim toDate As DateTime = enddate_picker_search_supplierinvoice.Value

然后是“.ToString”扩展名。

query &= "supplier_invoice_date >= '" & fromDate.ToShortDateString & "' AND supplier_invoice_date <= '" & toDate.ToShortDateString & "'"
invoicesresults_datagrid_search_supplierinvoice.DataSource = SelectDataTable(dt, query)