The binary is a byte array in .Net so maybe:
http://stackoverflow.com/questions/4959253/converting-sql-server-varbinary-data-into-string-c-sharp>When a SQL select command is executed, I always store the full SQL select command that was sent to SQL Server. This is useful for troubleshooting.
>
>It usually goes like this:
>
>
> ' If we have some parameters
> While loEnumerator.MoveNext
> loDataParameter = loEnumerator.Current
>
> loDataParameterSQLClient = loEnumerator.Current
> lcValue = loDataParameterSQLClient.Value.ToString
>
> ' Based on the type
> Select Case loDataParameterSQLClient.SqlDbType.ToString
>
> ' Integer, Binary
> Case "Int", "Binary"
>
> ' String
> Case "VarChar"
> lcValue = "'" + oApp.SQLServerGetValueForInsertionInScript(lcValue) + "'"
>
> ' Datetime
> Case "DateTime"
> ldDate = loDataParameterSQLClient.Value
> lcValue = "'" + ldDate.Year.ToString + "-" + _
> ldDate.Month.ToString.PadLeft(2, "0") + "-" + _
> ldDate.Day.ToString.PadLeft(2, "0") + " " + _
> ldDate.Hour.ToString.PadLeft(2, "0") + ":" + _
> ldDate.Minute.ToString.PadLeft(2, "0") + ":" + _
> ldDate.Second.ToString.PadLeft(2, "0") + "'"
>
> ' String
> Case "NVarChar"
> lcValue = "'" + oApp.SQLServerGetValueForInsertionInScript(lcValue) + "'"
>
>
>And, this may returns something like this:
>
>DECLARE @NoCompany Int
>DECLARE @MD5 Binary(16)
>
>SET @NoCompany=339
>SET @MD5=System.Byte[]
>
>SELECT CompanyFile.Numero,CompanyFile.Filename FROM CompanyFile (NOLOCK) WHERE CompanyFile.NoCompany=@NoCompany AND CompanyFile.MD5=@MD5
>
>But, as you can see, when this is a Binary type, I do not get something like 0xB3C54EFB6C02017046905007293650B1. There is already a ToString at the top which works ok for an Integer as I do not have to do additional processing. But, for a Binary type, ToString would simply show the type. How can I obtain the 0xB3C54EFB6C02017046905007293650B1 here?