access数据库插入html标记,被自动过滤,怎么回事??
比如我插入内容为
<strong>12345</strong>,数据表里显示的是12345,那些标记没了。。
再比如插入<img src="http:/xxxxx.jpg"> ,居然报错,好像是双引号的问题,
请教解决方法。。。。
[解决办法]
/// 去除HTML标记
public static string NoHTML(string strHtml)
{
strHtml= Regex.Replace(strHtml, @"<script[^>]*?>.*?</script>", "", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"<(.[^>]*)>", "", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"([\r\n])[\s]+", "", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"-->", "", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"<!--.*", "", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&(quot
[解决办法]
#34);", """, RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&(amp
[解决办法]
#38);", "&", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&(lt
[解决办法]
#60);", "<", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&(gt
[解决办法]
#62);", ">", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&(nbsp
[解决办法]
#160);", " ", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&(iexcl
[解决办法]
#161);", "\xa1", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&(cent
[解决办法]
#162);", "\xa2", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&(pound
[解决办法]
#163);", "\xa3", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&(copy
[解决办法]
#169);", "\xa9", RegexOptions.IgnoreCase);
strHtml= Regex.Replace(strHtml, @"&#(\d+);", "", RegexOptions.IgnoreCase);
strHtml.Replace("<", "");
strHtml.Replace(">", "");
strHtml.Replace("\r\n", "");
strHtml= HttpContext.Current.Server.HtmlEncode(strHtml).Trim();
return strHtml;
}