ASP.NET String Character Problem?

Question

2.00/5 (1 vote)

See more:

I have search part it has textbox and button. if you write a name in the textbox it goes to database and search names and name list comes under textbox sb.Append(temp).Append(Environment.NewLine);

you select a name line you click the name,name fill in the textbox but like this
'JOHN MARK'

so button click event has database code select from xxx where vvv='"+name+"'

so 'JOHN MARK' this gives me error because ' this character chause this error

how to clean this character from start of name and end of name

'JOHN MARK' JOHN MARK

Posted 8-May-12 7:52am

Member-2338430

Add a Solution

Comments

Sergey Alexandrovich Kryukov 8-May-12 15:51pm

Reason for my vote of 2
It makes very little to no sense doing advanced stuff like ASP.NET development or working with databases before learning very basic techniques and general programming. Asking such questions cannot help, because nobody will ask many thousands of them. Just a waste of time.
--SA

2 solutions

Solution 1

Use RegEx to process any type of string manipulation. Refer the article at: The 30 Minute Regex Tutorial[^]

Posted 8-May-12 7:55am

Ganesan Senthilvel

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)

**R. Giskard Reventlov** · Accepted Answer · 2012-05-08T07:58:00

Solution 2

Very simplistic answers:

1: change the db code to be vvv=" + name + "... though this would fail if the name passed didn't have the quotes!

2: "'JOHN MARK'".Replace("'","");

You should be able to work out what you need form this. Perhaps reading through the docs might help.

Posted 8-May-12 7:58am

R. Giskard Reventlov

Comments

Member-2338430 8-May-12 16:06pm

replace work why I didnt think THANK YOU