How to save and retrieve Bold and Italic words in sqlserver

Question

1.00/5 (1 vote)

See more:

Can Any One Tell Me That How To Save and Retrieve the Bold Text and para change in sqlserver
I have a text Box and user want to save a specific word BOLD when retrieve from database which was stored by himself

Posted 17-Mar-13 19:35pm

8400593361

Updated 20-Mar-19 16:07pm

Add a Solution

Comments

Shubham Choudhary 18-Mar-13 1:51am

hi!! when you write any content in textbox so it is behave like normal string!! but if you want to save different type of text save in sqlserver so save as html text and when you retrieve text on your website it shows like which you want...

6 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)

Aarti Meswania · Answer 1 · 2013-03-17T20:23:00

Solution 3

save data in RTF or HTML format

you can use Richtextbox control

Happy Coding!
:)

Posted 17-Mar-13 20:23pm

Aarti Meswania

Comments

8400593361 18-Mar-13 8:24am

when i am using rich textbox and save it into the database then an error is displaying

A potentially dangerous Request.Form value was detected from the client (FreeTextBox1="HELLO").
my code is:
con.ConnectionString = ConfigurationManager.ConnectionStrings["trialmlmConnectionString"].ConnectionString;

SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;

//demo1(@text nvarchar(max))
cmd.CommandText = "demo1";
cmd.Parameters.AddWithValue("@text", FreeTextBox1.Text);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();

}
catch (Exception ex)
{
Response.Write(ex.Message);
}

Aarti Meswania 18-Mar-13 8:32am

datatype in sql should be varbinary(max) you can get sample code online

kishore sharma · Answer 2 · 2013-03-17T22:06:00

While saving to database you fetch value using

JavaScript

innerHTML

property witch will give you text with html tags and after retrieving and loading in page you need to use

C#

Server.HtmlDecode(strValue)

methode to convert back to html format.
where strValue is the varchar value with html tag '<b>bold</b>'

S R JHALA · Answer 3 · 2013-03-17T19:57:00

Solution 1

Just use the Editor and save that data in sql server and that field should be NVARCHAR
so what you save you will get back same when you retrieve.

Posted 17-Mar-13 19:57pm

S R JHALA

Nitin S · Answer 4 · 2013-03-17T21:36:00

Solution 4

You can convert the formatted text into Binary and save it into DB with VARBINARY datatype,

when retriving again you need to convert binary to the text format.

Posted 17-Mar-13 21:36pm

Nitin S

Avik Ghosh22 · Answer 5 · 2013-03-17T21:49:00

Solution 5

http://aspsnippets.com/Articles/Using-Tiny-MCE-Rich-TextBox-in-ASP.Net.aspx[^]

Posted 17-Mar-13 21:49pm

Avik Ghosh22

8400593361 · Answer 6 · 2013-03-18T01:11:00

when i am using rich textbox and save it into the database then an error is displaying

A potentially dangerous Request.Form value was detected from the client (FreeTextBox1="dafzfs").

con.ConnectionString = ConfigurationManager.ConnectionStrings["trialmlmConnectionString"].ConnectionString;


        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandType = CommandType.StoredProcedure;
      
        //demo1(@text nvarchar(max))
        cmd.CommandText = "demo1";
        cmd.Parameters.AddWithValue("@text", FreeTextBox1.Text);
        try
        {
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
           
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }