datagridview从字符串到日期选择查询 [英] datagridview select query from string to date
问题描述
嗨
我正在使用访问数据库,vb.net
来过滤我使用的datagridview
Sales_ItemsDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_Items.Select((Convert(category,'System.String')LIKE'& search2&')
现在我的问题
我的日期是数据库中的字符串
日期格式是31/12/2001
我希望过滤两个日期之间的dategridview,所以我发现了
Sales_ListDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_List.Select((转换(invoice_date,'System.String')< ='& DateTimePicker2.Value&'转换(invoice_date,'System.String')> ='& DateTimePicker1.Value&') )
但是肯定这给了我有趣的结果,因为它认为日期是字符串...
但我没有改变
(转换(invoice_date,'System.String')
到日期格式
ca n任何一个帮助请.....
尝试使用LINQ
Sales_ListDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_List.AsEnumerable()
.Where(r = > r.Field< datetime>( invoice_date)< = DateTimePicker2.Value&& r.Field< datetime>( invoice_date)> ; = DateTimePicker1.Value)
.CopyToDataTable();
http://msdn.microsoft.com/en-us/library/bb669073(v=vs.110)。 aspx [ ^ ]
Hi
I am using access database , vb.net
to filter my datagridview I used
Sales_ItemsDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_Items.Select(("Convert(category, 'System.String') LIKE '" & search2 & "'")
now my problem
my date is string in the Database
date format is 31/12/2001
and i want to filter the dategridview between 2 dates so i uesed
Sales_ListDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_List.Select(("Convert(invoice_date, 'System.String') <= '" & DateTimePicker2.Value & "' AND Convert(invoice_date, 'System.String') >= '" & DateTimePicker1.Value & "'"))
but sure that gave me funny results as it considered the date as string...
but i failed to change the
("Convert(invoice_date, 'System.String')
to date format
can any one help Please.....
Try with LINQ
Sales_ListDataGridView.DataSource = Me.M_B_DATABASEDataSet.Sales_List.AsEnumerable() .Where(r => r.Field<datetime>("invoice_date") <= DateTimePicker2.Value && r.Field<datetime>("invoice_date") >=DateTimePicker1.Value) .CopyToDataTable();
http://msdn.microsoft.com/en-us/library/bb669073(v=vs.110).aspx[^]
这篇关于datagridview从字符串到日期选择查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!