Hi, all
Could anny one give me help how can I use like operator with these data
types "integer , datetime or boolean" in DataView.RowFil ter
Actually when I try to get the data from dataview using rowfilter with
like operator
Its working fine when data type of searching column is "string" .
But if data type is "integer , datetime or boolean" its throws
error
This is the code which works fine
Dim dv As New DataView
dv = dttblFullData.D efaultView
dv.RowFilter = "first_name like 'lilly%'"
dgData.DataSour ce = dv
And this is not works fine
Dim dv As New DataView
dv = dttblFullData.D efaultView
dv.RowFilter = "Employee_i d like '4552%'"
dgData.DataSour ce = dv
or
Dim dv As New DataView
dv = dttblFullData.D efaultView
dv.RowFilter = "Birth_date like '08/12/2%'"
dgData.DataSour ce = dv
or
Dim dv As New DataView
dv = dttblFullData.D efaultView
dv.RowFilter = "is_Deleted like 1"
dgData.DataSour ce = dv
thanks