Filter number in a DataView using RowFilter in C#4.0

3
votes

I'm trying to filter my DataView DataSet using RowFilter.

I would like to perform a like statement on an Integer column

So something like this: 

myDataView.RowFilter ="ID LIKE %1%";

This works fine for string columns but I receive an error when trying this will integers. I receive the follow error: Cannot perform 'Like' operation on System.Int32 and System.Int32.

Anyway of doing a LIKE statement on numbers?

Thanks in advance.

3
c#dataviewrowfilter

3 Answers

4
votes

It worked with me:

"Convert(DataGridColumnName, 'System.String') LIKE '%" & txtBox.Text & "%' "
1
votes

You must convert using cast.

"Convert(ID, 'System.String') LIKE  %1%"
0
votes

This gets the specific item requested. It works on one item exactly

"Convert(DataGridColumnName, 'System.String') LIKE '%" & txtBox.Text & "%' "

Example 1:

 DV.RowFilter = "Convert( TicketNo , 'System.String') LIKE  '%" + txtTicketNo.Text + "%'

This only receive the exact ticket number if you want to retreive items like that start with it receives all items that start with

Example 2:

DV.RowFilter = "Convert( TicketNo , 'System.String') LIKE  '" + txtTicketNo.Text + "%' ";

In Theory the first Example should be looking in the whole string and searching for matches. The one that I have done does not do that maybe I had missed something,