Cannot perform 'Like' operation on System.DateTime and System.String.

See more:

C#

Hello,

I have grid view with 4 column ( ID , name ,sub , age ) . and i write code for search on them from data grid.

private void button4_Click(object sender, EventArgs e)
        {
 DataView dv = new DataView(dbdataset);
dv.RowFilter = string.Format("name LIKE'%{0}%'OR sub LIKE'%{0}%'OR age LIKE'%{0}%'",txt.Text);
 dataGridView1.DataSource = dv;
        }

But this error appear to me ( Cannot perform 'Like' operation on System.DateTime and System.String.)

Any one can help me in this?

Kind Regards,