C# string data and SQL 2000 binary data

Feb 19 2003 8:19 AM

I have a string-representation of a GUID being passed into my c# web service, and I want to look this value up in my SQL 2000 table. However, my GUIDS in the database are stored as binary. How can I compare these two values to find a match in the table? I tried SQL convert, cast, but they didn't work. Are there any C# conversion functions I can use? The two values I would like to compare look similar to: string GUID: 9F1F7BF37997604DB88249E9FFB2AD66 -- in C# binary GUID: 0x9F1F7BF37997604DB88249E9FFB2AD66 -- in DB Many thanks! Aaron

Answers (1)

How do I draw complex lines

Loading an xml file in the DOM object.