Datatable.select with byte array VB.NET

Question

I have populated a datatable from a SQL stored procedure and need to do further filtering on the datatable. The datatable holds data that is returned from the SQL DB as varbinary and is stored in the datatable as a byte array. I am attempting to pass TheData!Hash which is also a byte array.

When I need to filter the datatable I have use the following:

Dim sQuery0 As String = "Hash=" & TheData!Hash
Dim ResultRows As DataRow() = dt.Select(sQuery0)

I understand that the TheData!Hash is a byte array and cannot be converted to a string in this way but how on earth do I pass the byte array in the Select filter expression?

Answer 1

I don't believe you'll get this to work. What's the type of TheData!Hash? Byte()? Then if you did this comparison in code, it would be a reference comparison in any case.

Take a look at LINQ to DataSet. You'll find it much more flexible than the Select method, which is from .NET 1.0.