如何使用条件过滤datagridview行 [英] how do filter datagridview rows with condition

问题描述

嗨所有



i希望过滤我的datagridview与日期栏



注意：日期是波斯语格式并以字符串格式存储



我的过滤器是：

1-Today

2-Today and Past

3-Today and Next

4-All Days



i为这些代码写了这些代码：< br $>

hi all

i want filter my datagridview with date column

NOTE : date is in persian format and stored with string format

my filters are :
1-Today
2-Today And Past
3-Today And Next
4-All Days

i writed this codes for any of they :

private void rdo_today_CheckedChanged(object sender, EventArgs e)
        {
            if (rdo_today.Checked)
            {
                (dgv_work.DataSource as DataTable).DefaultView.RowFilter = string.Format("work_date = '{0}'", dtp_farsi.Text);
            }
        }

        private void rdo_todaypast_CheckedChanged(object sender, EventArgs e)
        {
            if (rdo_today.Checked)
            {
                (dgv_work.DataSource as DataTable).DefaultView.RowFilter = string.Format("work_date < '{0}'", dtp_farsi.Text.Trim());
            }
        }

        private void rdo_todaynext_CheckedChanged(object sender, EventArgs e)
        {
            if (rdo_today.Checked)
            {
                (dgv_work.DataSource as DataTable).DefaultView.RowFilter = string.Format("work_date >= '{0}'", dtp_farsi.Text);
            }
        }

        private void rdo_alldays_CheckedChanged(object sender, EventArgs e)
        {
            selectAllRecord();
        }

现在：

只有今天和AllDays过滤器工作，今天和今天下一个Dosnt工作



为什么？



请帮助我



非常感谢

Now :
Only "Today AND AllDays" Filters Work , And "TodayPast And TodayNext" Dosnt Work

Why ?

Please Help Me

thanks a lot

推荐答案

你把它存放为一个字符串，你不能做一个如果小于字符串值，则需要先将字符串转换为日期和时间或数字。您可以尝试在任何一方抛出＃，但我怀疑它会有所帮助。

You are storing it as a string, you can't do a less than on a string value, you need to convert the string to a date and time or number first. You could try throwing # on either side, though I doubt it would help.

这篇关于如何使用条件过滤datagridview行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！