Hi,

I have a column with SQL Server type binary(20) (contain a sql handle, ex :
0x01000800B73B573B98C6B1030000000000000000)

I want to convert this column to string value with this code :

string sql_hndl = MyDataRow["ColWithBinaryType"].tostring;

I'm expecting '0x01000800B73B573B98C6B1030000000000000000' string value, but
I've got 'array[]' value

Is there any simple way to convert sql server binary type to string

Thank you for your help

The first question I would ask is, "what on earth do you expect to be able to
do with the string representation of a SQLHandle?".

You will probably need to do something like:

string s = System.Text.Encoding.UTF8.GetSTring( (byte[])
MyDataRow["ColWithBinaryType"] )

Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net




"SM" wrote:

> Hi,
>
> I have a column with SQL Server type binary(20) (contain a sql handle, ex :
> 0x01000800B73B573B98C6B1030000000000000000)
>
> I want to convert this column to string value with this code :
>
> string sql_hndl = MyDataRow["ColWithBinaryType"].tostring;
>
> I'm expecting '0x01000800B73B573B98C6B1030000000000000000' string value, but
> I've got 'array[]' value
>
> Is there any simple way to convert sql server binary type to string
>
> Thank you for your help
>
>
>

Thank you
The conversion did not work, I need SQL Handle to capture query that block
other process (::fn_get_sql())
Never mind I've process all things in server side



"Peter Bromberg [C# MVP]" <(E-Mail Removed)> wrote in
message news:2AF21AA0-8C03-46C0-AA92-(E-Mail Removed)...
> The first question I would ask is, "what on earth do you expect to be able
> to
> do with the string representation of a SQLHandle?".
>
> You will probably need to do something like:
>
> string s = System.Text.Encoding.UTF8.GetSTring( (byte[])
> MyDataRow["ColWithBinaryType"] )
>
> Peter
> --
> Site: http://www.eggheadcafe.com
> UnBlog: http://petesbloggerama.blogspot.com
> Short urls & more: http://ittyurl.net
>
>
>
>
> "SM" wrote:
>
>> Hi,
>>
>> I have a column with SQL Server type binary(20) (contain a sql handle,
>> ex :
>> 0x01000800B73B573B98C6B1030000000000000000)
>>
>> I want to convert this column to string value with this code :
>>
>> string sql_hndl = MyDataRow["ColWithBinaryType"].tostring;
>>
>> I'm expecting '0x01000800B73B573B98C6B1030000000000000000' string value,
>> but
>> I've got 'array[]' value
>>
>> Is there any simple way to convert sql server binary type to string
>>
>> Thank you for your help
>>
>>
>>

"SM" <(E-Mail Removed)> wrote in message
news:##(E-Mail Removed)...
> Hi,
>
> I have a column with SQL Server type binary(20) (contain a sql handle, ex
> :
> 0x01000800B73B573B98C6B1030000000000000000)
>
> I want to convert this column to string value with this code :
>
> string sql_hndl = MyDataRow["ColWithBinaryType"].tostring;
>
> I'm expecting '0x01000800B73B573B98C6B1030000000000000000' string value,
> but I've got 'array[]' value
>
> Is there any simple way to convert sql server binary type to string
>
> Thank you for your help
>

Quick sample:

byte[] bytes = dataRow.BinaryFieldHere;
StringBuilder sb = new StringBuilder();
foreach (byte b in bytes) {
sb = sb.Append(b.ToString("X").PadLeft(2, '0'));
}

if (sb.Length > 0) {
sb = sb.Insert(0, "0x");
}

string binaryString = sb.ToString();

HTH (untested),
Mythran