C#.Net get SQL image datatype

[Jason Huang]

Hi,

I have a table which datatype in SQL Server 2000 is "image".
How do I get that special datatype in my C#.Net Windows Form? Given using
the SqlDataAdapter method.
Thanks for help.


Jason

 

[Nicholas Paldino [.NET/C# MVP]]

Jason,

The SqlDataAdapter should populate the data set with a byte array. You
can then just use the bytes as you wish.

Hope this helps.

 

[Jason Huang]

Thanks Nicholas!
The byte array I got is [125,0,108,0,122,0,125,0,108,0,123,0],
but when I do the SELECT command in the SQL Query Analyzer,
the output is 0x7D006C07A007D006C07B00.
What's the real READABLE value?

Jason,

The SqlDataAdapter should populate the data set with a byte array. You
can then just use the bytes as you wish.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Hi,

I have a table which datatype in SQL Server 2000 is "image".
How do I get that special datatype in my C#.Net Windows Form? Given
using the SqlDataAdapter method.
Thanks for help.


Jason