how to insert hyperlink text using rich textbox in sql server

Can you share your code? What have you tried already? Do you have only link in RichTextBox or there is more text and you want to find link and then save it to DB?

cserakeshcseranjan 12-Dec-14 3:48am

sure this my code
{
SqlConnection con = new SqlConnection(conn);
con.Open();
SqlCommand cmd = new SqlCommand("insert into RichTextBoxData(RichTextData) values(@Richtextbox)", con);
cmd.Parameters.AddWithValue("@Richtextbox", FreeTextBox1.Text);
cmd.ExecuteNonQuery();
con.Close();
FreeTextBox1.Text = "";
lbltxt.Text = "Data Inserted Successfully";
BindGridview();
}

i want to insert like "click here" with hyper link so how does it ? help me.

cserakeshcseranjan 12-Dec-14 3:56am

help me dears plz.

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

Maciej Los · Answer 1 · 2014-12-11T21:43:00

cserakeshcseranjan wrote:
while i am storing data in database but it accepting only simple data.b ut it is not accepting html tags like bold.

It depends on database type. The field which holds rtf/html data should be: BLOB, CLOB, MEMO data type...

Please see:
http://www.datanamic.com/support/storing-rtf-in-db.html[^]
Store RTF Data in a SQL Server Database[^]
Storing data of rich text box to database with formatting[^]
http://stackoverflow.com/questions/15983278/storing-data-of-rich-text-box-to-database-with-formatting[^]

Raul Iloc · Answer 2 · 2014-12-11T21:40:00

Solution 1

You should encode the HTML tags before to send them for storing in your database, and to decode them back when you want to show them into the UI.

Here is a link about web encoding: http://demo.nickname.net/demo/testpak/encode.pl[^]

Posted 11-Dec-14 21:40pm

Raul Iloc