Link to home
Start Free TrialLog in
Avatar of johnnyg123
johnnyg123Flag for United States of America

asked on

Maintain HTML from Sql server field in ASP.net form

I have a sql server table named ShopInfo that has a bunch of fields containing shop information

the shophours field contains the shop hour in an html table

the following is an example

<table width="100%" cellpadding="2" cellspacing="0" style="border:solid 0px #dcdcdc;"><tr><td colspan="2" style="background-color:#f5f5f5;border:solid 1px #dcdcdc;"><img src="./images/icon-clock.gif" style="vertical-align:bottom;" alt="" border="0" /> <b>Store Hours:</b></td></tr><tr><td style="border:solid 1px #dcdcdc; width:40%;">Monday-Friday:</td><td style="border:solid 1px #dcdcdc;">8:00am - 6:00pm</td></tr><tr><td style="border:solid 1px #dcdcdc;">Saturday:</td><td style="border:solid 1px #dcdcdc;">8:00am - 5:00pm</td></tr><tr><td style="border:solid 1px #dcdcdc;">Sunday:</td><td style="border:solid 1px #dcdcdc;">10:00am - 4:00pm</td></tr></table>

The html format for each of the shop hour entries is the same except for the hours themselves

I have attached a screen shot of what the generated html looks like

Currently, the user sends a request to IT if the hours need to change and we manually go into thetable and make the changes

The user would like a form to be able to change the hours themselves.

Trying to determine a way to present the info in a user friendly format to allow users to change hours and then write the updated html back to the table

Any suggestions as to a good way to approach this?

Avatar of johnnyg123
johnnyg123
Flag of United States of America image

ASKER

Use TinyMCE and allow them to edit the HTML (rather than structuring it as a form).
ASKER CERTIFIED SOLUTION
Avatar of Mlanda T
Mlanda T
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
For a sample how you can use FreeTextBox: http://www.a2zdotnet.com/View.aspx?Id=28
Seriously don't touch FreeTextBox with a barge pole... I used it initially and soon got very frustrated.

Even DotNetNuke changed to using FckmEditor, but having used them all I think TinyMCE is the way to go.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for all the feed back!

I wnet with the quick fix for now but I am going to play around with TinyMCe as time permits