Hi,
I need to do a wild card search for all the fields in my table irrespective
of whether its a numeric/date or string field . The data should filter only
these data and show in the datagridview while I bound the datatable to it.
Lets say I have the following table

Name | DOB | SAL | Address

Jane |25/12/1976 | 25000 | Parkview boulevard
Hart |19/10/1988 | 16000 | Hunstville
Charles |15/12/1968 | 28000| Atlanta
Kate |25/12/1975 | 25000 | Parkview boulevard
Ron |25/12/1978 | 25000 | Parkview boulevard
Juane |25/12/1973 | 25000 | Parkview boulevard
Nick |25/12/1972 | 25000 | Parkview boulevard

Lets assume that this data is already there in my dataset with a data
tablename "Employee" and dataset name "dsEmployee"
While I give a search in this like

dsEmployee.tables["Employee"].DefaultView.RowFilter = "name like '%25/12%'
OR DOB like '%25/12%' OR SAL like '%25/12%' OR Address like '%25/12%'

I get an error "Cannot perform 'Like' operation on System.Date or
System.Double . Is there a workaround on this. I want to do a wildcard search
and filter a set of rows irrespective of the datatype of the datacolumn

Iam expecting an output of the following to be listed in the datagridview
for the above output

Jane |25/12/1976 | 25000 | Parkview boulevard
Kate |25/12/1975 | 25000 | Parkview boulevard
Ron |25/12/1978 | 25000 | Parkview boulevard
Juane |25/12/1973 | 25000 | Parkview boulevard
Nick |25/12/1972 | 25000 | Parkview boulevard

Any help is very much appreciated