如何保存在SQL服务器的HTML数据

问题描述:

我有反馈面板,用户可以通过编写HTML格式化反馈 AJAX HTML编辑

I have feedback panel where user can write HTML formated feedback using AJAX HTMLEditor

我要保存在SQL Server此HTML数据

I want to save this HTML DATA in SQL server

HTML源代码

This is <span style="font-weight: bold; ">nice</span> question

HTML输出

This is nice question

现在我怎么可以搜索到我的数据库,如果你的发现是好的,那么我的查询不能反应很好,因为数据库包含HTML标签了。

Now how can i search to my database if your find "is nice" then my query can not response is nice because database contains HTML tags too.

那么,保存和使用SQL查询和检索放HTML数据的最佳做法; ASP.net。

So what are best practices to save and retrieve HTML data using SQL Query & ASP.net.

您可能会得到一些里程了SQL Server的全文搜索功能。这里是一个描述应用全文搜索到HTML文本存储在SQL Server的战略资源:

You might get some mileage out the SQL Server's full-text search capability. Here is a resource that describes strategies to apply full-text search to HTML text stored in SQL Server:

http://www.developmentnow.com/blog/SQL+Server+2005+Full+Text+Search+On+HTML+Documents.aspx