需要在gridview C＃winform中搜索来自datepicker的数据 [英] need to search data from datepicker in gridview C# winform

问题描述

 BindingSource bs =  new  BindingSource（）; 
 bs.DataSource = dgvmember.DataSource; 
 bs.Filter = dgvmember.Columns [ 2 ]。HeaderText.ToString（）+   LIKE'％ + dtpsdate.Text +  ％' ; 
 dgvmember.DataSource = bs; 

我有1个datepicker

1 gridview& 1个按钮



i用于搜索从datepicker到datagridview的Entry_date



但我收到错误不能在System.DateTime和System.String上执行'Like'操作。



< img src ='http：//s5.postimg.org/d6fo8mgx3/Untitled.png'border ='0'alt =Untitled/>




[url = http://postimg.org/image/rcvf3urs3/] [img] http：//s5.postimg .org / rcvf3urs3 / Untitled.jpg [/ img] [/ url]





i试过这个

 bs.Filter = dgvmember.Columns [ 2 ]。HeaderText.ToString（）+   ='＃ + dtpsdate.Text +  ＃' ; 

但我得到了但现在我得到了日期转换错误

解决方案

错误信息非常清楚。您不能使用 Like 运算符来比较 DateTime 数据类型。看看这里： DateTime Operators [ ^ ]



尝试这样的事情：

 bs.Filter =  string .Format(  {0} ='{1：yyyy-MM-dd}'，dgvmember.Columns [ 2 ]。HeaderText，dtpsdate）; 

BindingSource bs = new BindingSource();
            bs.DataSource = dgvmember.DataSource;
            bs.Filter = dgvmember.Columns[2].HeaderText.ToString() + " LIKE '%" + dtpsdate.Text + "%'";
            dgvmember.DataSource = bs;

i have 1 datepicker
1 gridview & 1 button

i used this for searching Entry_date from datepicker in to datagridview

but i got error "Cannot perform 'Like' operation on System.DateTime and System.String."

<img src='http://s5.postimg.org/d6fo8mgx3/Untitled.png' border='0' alt="Untitled" />


[url=http://postimg.org/image/rcvf3urs3/][img]http://s5.postimg.org/rcvf3urs3/Untitled.jpg[/img][/url]


i tried this

bs.Filter = dgvmember.Columns[2].HeaderText.ToString() + " = '#" + dtpsdate.Text + "#'";

but i got but now i got date converting error

解决方案

The error message is quite clear. You can't use Like operator to compare DateTime data type. Have a look here: DateTime Operators[^]

Try something like this:

bs.Filter = string.Format("{0} = '{1:yyyy-MM-dd}'", dgvmember.Columns[2].HeaderText, dtpsdate);

这篇关于需要在gridview C＃winform中搜索来自datepicker的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！