Format a string with escape characters

[ProfReynolds]

Is there a way to take a string and format it such that it will be accepted in a SQL XML cell?

I had thought that httpUtility.HTMLEncode would do the trick, but it doesn't quite handle it.

Thanks!

 

[jmeckley]

There is a SqlDbType.Xml enumeration. try setting the type to this and assign the value.

in terms of building the xml string fro sql, that you will probablly need to design on your own.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[ProfReynolds]

Thanks.

I ended up using Cast(string as xml) in the Insert statement.

Thanks for your help!