how to edit html inside a database

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hi, I recently inherited a website with aspx pages. Most of the html is located inside a SQL Server 2005 database, and then aspx pulls it from there to include in the default.aspx file. Is there any tool I can use to edit the database to edit the html, or is it just TSQL I would use?

Posted 31-Aug-12 4:38am

EuniceRH

Add a Solution

Comments

[no name] 31-Aug-12 10:47am

Why can't you use SSMS and edit the data directly?

EuniceRH 31-Aug-12 10:56am

I can, actually use the godaddy equivalent, I was just looking for an easier way, wondering if the previous developer used some kind of tool to edit the database html.

[no name] 31-Aug-12 10:59am

Probably not. It's just text. If he did use some sort of a tool, he probably developed it himself.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

EuniceRH · Answer 1 · 2012-08-31T05:03:00

Solution 2

With Wes Aday's help I've solved this myself. He said you have to use SSMS (TSQL). No thanks to Christian Amado, I had googled it and found no answer.

Posted 31-Aug-12 5:03am

EuniceRH

**AmitGajjar** · Answer 2 · 2012-08-31T05:05:00

Hi,

If your HTML content in the database is XHTML then you can do that using XML datatype in the database. you can update specific information directly in the database.

Below are some useful links that may help you,

XQuery and XMLDML[^]

Scritp to insert/Update xml data in database[^]

Hope this helps you
Thanks
-Amit Gajjar

Christian Amado · Answer 3 · 2012-08-31T04:47:00

There is a very cool site around the net. The site what I talking about is very useful when you learn to use it.

That site is like a genius in a bottle. The only difference is that you should not rub the lamp at all. Just type your questions there :)

The site you can find here.

You can copy your html inside sql in Web Expression or any another tool.

Hope you can find it useful.

how to edit html inside a database

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0