how to assign quotation to the textbox from database

Question

0.00/5 (No votes)

See more:

Hi,
I want to assign quotation mark(') in the textbox
for ex

i have stored let say microsoft'''''''s in the database
i want to retrive this value from the database and assign this to the textbox ,
But the problem is the quotation(') is dispaly as
microsoftquotquotquotquotquotquotquotquotquotquotquotquotquots ,i want it as
i have stored it in the database ie microsoft'''''''s

Posted 30-Jan-13 23:20pm

aassaahh

Add a Solution

Comments

AshishChaudha 31-Jan-13 5:31am

how you are saving your data?? using stored procedure or parameterized query of inline query..please elaborate your question by using Improve question.

Ankur^\m/ 3-Feb-13 6:22am

an upvote, if the answer helped would have been nice. :)

3 solutions

Solution 3

use

C#

Replace("quot","'");

Posted 30-Jan-13 23:41pm

AdityaPratapSingh

Solution 1

Hmmm... try to put this sign "@" in front of quotation.

Posted 30-Jan-13 23:25pm

OscarTheWild

Comments

aassaahh 31-Jan-13 5:36am

but how ??? user is going to enter anything in the textbox .I am assign it to the textbox as
txtCompany.Text = row.Cells[3].Text.Replace(" ", "");

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)

Ankur^\m/ · Accepted Answer · 2013-01-30T23:32:00

Solution 2

& quot ; [without any spaces]
is encoded html for double quotes ("). There is something wrong with how you are storing it. It must have an ampersand prefix and semicolon suffix.

You can use HttpServerUtility.HtmlDecode Method (String)[^] to decode the string to normal text.

Posted 30-Jan-13 23:32pm

Ankur^\m/

Comments

Ankur^\m/ 31-Jan-13 5:34am

I was struggling to write & quot ; without spaces. They encode it here as well.