want to remove some marks form some string

Question

1.00/5 (1 vote)

See more:

i have following code

string n = dateTimePicker1.Value.ToString("yyyy-MM-dd");

which give me following output--------------"2014-07-11"

now i want to remove double inverted commams from this string how could i do this....

Posted 11-Jul-14 0:34am

Member 10891595

Updated 11-Jul-14 0:56am

v2

Add a Solution

Comments

johannesnestler 11-Jul-14 6:42am

what are inverted commams? Anyway, better you Format the string in the way you want it in the first place (when you give the Format string)?

Thanks7872 11-Jul-14 6:51am

I suspect this question was posted just after seeing result while debugging..:laugh:

ShobuGpta 11-Jul-14 6:53am

u mean double quotes??

Member 10891595 11-Jul-14 6:58am

yes

Member 10891595 11-Jul-14 7:07am

what happen sir is there is any solution ;

ShobuGpta 12-Jul-14 1:07am

did u checked value of string n while debugging??

1 solution

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)

CHill60 · Accepted Answer · 2014-07-11T01:07:00

Solution 1

I'll put you out of your misery before you become the butt of too many jokes.

The double-quotes are not part of your string.

That's just the way it is being displayed in the Locals or Output windows, or when you hover over n in debug mode.

Stick the string into a Label or TextBox to prove my point - there will be no double-quotes

Posted 11-Jul-14 1:07am

CHill60

Comments

Thanks7872 11-Jul-14 7:08am

:laugh:

CHill60 11-Jul-14 7:12am

Bless them!

KaushalJB 11-Jul-14 7:13am

no rains this year...don't laugh :D

Member 10891595 11-Jul-14 7:15am

if this have no meaning of double quotes then how i use this string value in following query

dt = obj.GetDataTable("SELECT * from mobilesubscriberdata1 where m_date="+"'n'");

because i have an error when i using this above type pls suggest me for what type of modification required in above query.

[no name] 11-Jul-14 7:35am

You will get an error because that is invalid SQL.

Member 10891595 11-Jul-14 7:47am

what is correct form of this sql pls suggest me

[no name] 11-Jul-14 8:15am

Try dt = obj.GetDataTable("SELECT * from mobilesubscriberdata1 where m_date='"+ n + "'");
Then go to www.w3schools.com to start learning about SQL.
After that, get yourself a decent book on basic programming and work through it. Not knowing how to construct a simple string suggests a fundamental lack of programming knowledge.
Then do some research on SQL injection attacks to learn why you should not be constructing SQL statements by string concatenation.

CHill60 11-Jul-14 9:55am

Virtual 5!

Member 10891595 11-Jul-14 7:22am

pls sir help me