Re: FN-FORUM: ASP.NET dataset manipulation

date posted 6th August 2007 14:32

If you are running through code it may be you want to be using
SecurityElement.escape

That may be more useful than one-off replaces as it is then a general
solution.

http://msdn2.microsoft.com/en-us/library/system.security.securityelement.escape(VS.80).aspx

-ben

Craig wrote:
> Thanks for the replies guys,
>
> Yes, I agree, a DataReader would be better, I don't use Datagrids myself if
> I can help it.
>
> I've decided to write some functions to do "one-off" global replaces in the
> database for non-compliant tags, etc. Don't know why I didn't think of it
> before.
>
> Thanks again.
>
> Craig
>
> -----Original Message-----
>
> Craig wrote:
>
>> MySQL 5.0
>>
>>
> In that case you can't use the SQL Server built in XML stuff I guess...
>
> I would probably swap that first dataset for a DataReader that just
> retrieves the data cleans it up and then loads it into the output
> dataset- for most stuff I avoid DataSets as they offer a lot of extra
> overhead but they're pretty handy for XML.
>
> -ben
>
>
>
>