Sharepoint - Can You Output Unfiltered HTML from a Database?

Question

Our customers have asked for Sharepoint and, of course, we are having to implement features for which Sharepoint wasn't really designed. We are first trying to stretch the in-house webparts as far as we can, so we are doing a lot of the work in stored procedures, user defined functions, and custom views in the MSSQL DB.

I am generating html links from fields in the database and wish to display them in something like a Data View web part. Of course, all of the data being displayed is being filtered so that it shows up as unrendered HTML. Is there a way around this?

Alternatively, is there any type of web part that can connect to another webpart or Data source and display unfiltered text/html from that source?

Answer 1

You need to use the XSLT in the dataview webpart to control the rendering. You have full control over what html is created. disable-output-escaping if necessary.

Answer 2

I get a feeling you’re customizing SharePoint the wrong way. Either that your I don’t really understand the description of your question. I would appreciate a more detailed description of exactly what you are trying to accomplish.

As far as I know you should NEVER touch the SharePoint database directly. I think you should focus on creating lists, field types, WebParts and whatever SharePoint components you might need; instead of messing around in the content database.

SharePoint got a decent development API. It takes some time to learn, but in the end it’s probably worth it.

You can connect your custom made WebParts in SharePoint, here is a sample.