johnnyg123
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:#f 5f5f5;bord er:solid 1px #dcdcdc;"><img src="./images/icon-clock.g if" style="vertical-align:bott om;" alt="" border="0" /> <b>Store Hours:</b></td></tr><tr><t d 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><t d 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?
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:#f
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?
Use TinyMCE and allow them to edit the HTML (rather than structuring it as a form).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Even DotNetNuke changed to using FckmEditor, but having used them all I think TinyMCE is the way to go.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
I wnet with the quick fix for now but I am going to play around with TinyMCe as time permits
ASKER
ShopHours.doc