Filtering on a Guid

Last post 07-09-2008 2:24 PM by C1_SteveB. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

07-02-2008 9:47 AM

AmosWittenberg
Joined on 02-13-2006
Posts 6

Filtering on a Guid

Reply Contact

Hi All!

Does anyone know how to filter a DataView in a DataViewSet on a column that has type Guid? My present workaround is to add an extra column with the Guid cast to string and filter on that column. But this strikes me as unelegant in the extreme.

Problem is: T-SQL syntax "column = ' 6F9619FF-8B86-D011-B42D-00C04FC964FF'" is not supported. it does not cause an exception but it doesn't work either.

Any enlightenment is welcome.

Amos Wittenberg

Filed under: filter

07-09-2008 2:24 PM In reply to

C1_SteveB
Joined on 04-22-2008
Posts 71

Re: Filtering on a Guid

Reply Contact

Amos,

In regards to your forum question, C1 ADO.NET DataExtender support and has the ability to filter a DataView only on rows, using this code...

[C#] public event C1ViewFilterRowEventHandler FilterRow

[Visual Basic] Public Event FilterRow As C1ViewFilterRowEventHandler

C1 ADO.NET DataExtender does not have the ability to filer a DataView on a column

as it does on a row though.

- Steve

Page 1 of 1 (2 items)