Using Oledb dataadapter c#

[chandler83]

Hi, i am using c# and sql server 2000. i want to execute this below query in my application using oledb dataadapter. sql query: select preferencevalue from ParticipantPreference for xml raw; (also the above column contains an XML data as a value in it.) this query gives me an xml formatted correct output when i use SQL dataadapter. If i use oledb dataadapter my result is in BYTE array format... plz help:(( me.

[WillemM]

I think it has something to do with oledb. Can you try the following with that byte array? byte[] data = ...; //The data array that you got from the adapter ASCIIEncoding.GetString(data);

WM. What about weapons of mass-construction?