POSSIBLE FOR GETTING VALUES ALONG WITH SINGLE QUOTE

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

SQL-Server

GIVE ME A SAMPLE QUERY IF POSSIBLE WHEN EXPORT DB,THE OUTPUT CONTAINS LIKE
'12345'

THANKS IN ADVANCE...........

Posted 9-Sep-12 23:21pm

thilagpravin

Add a Solution

Comments

manognya kota 10-Sep-12 5:24am

what is the query about?Please elaborate

thilagpravin 10-Sep-12 6:01am

WHILE EXPORT FROM DB AS 'CSV' FILE I NEED THAT CONDITION,I FIND OUT THE SOLUTION.AFTER THAT,WHEN AM IMPORT INTO DB FROM SAME 'CSV' FILE ,IMPORT AS ORIGINAL VALUE WITHOUT THE SINGLE QUOTE USING C#.NET.HOW TO ACHIEVE IT.CAN U HELP ME PLS..

Sunil Kumar Pandab 10-Sep-12 5:27am

Everything is possible. First you just have to clarify your problem.

thilagpravin 10-Sep-12 6:02am

WHILE EXPORT FROM DB AS 'CSV' FILE I NEED THAT CONDITION,I FIND OUT THE SOLUTION.AFTER THAT,WHEN AM IMPORT INTO DB FROM SAME 'CSV' FILE ,IMPORT AS ORIGINAL VALUE WITHOUT THE SINGLE QUOTE USING C#.NET.HOW TO ACHIEVE IT.CAN U HELP ME PLS..

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)

_Amy · Accepted Answer · 2012-09-09T23:34:00

Solution 1

Try using CHAR(39) in your code. Use this:
SQL:

SQL

PRINT CHAR(39) + '12345' + CHAR(39)

C#:

C#

string ss = "12345";
SqlCommand cmd = new SqlCommand("INSERT INTO tblTemp(Code) VALUES(CHAR(39)+'"+str+"'+CHAR(39))", con);
//con is your connection object

--Amit

Posted 9-Sep-12 23:34pm

_Amy

v2

Comments

thilagpravin 10-Sep-12 5:52am

THANKS AMIT.ITS WORKING...

thilagpravin 10-Sep-12 5:57am

WHILE EXPORT FROM DB AS 'CSV' FILE I NEED THAT CONDITION.AFTER THAT,WHEN AM IMPORT INTO DB FROM CSV FILE IMPORT AS ORIGINAL VALUE WITHOUT THE SINGLE QUOTE USING C#.NET.HOW TO ACHIEVE IT.CAN U HELP ME PLS..

_Amy 10-Sep-12 6:10am

Just do vice verse. Remove the CHAR(39) i.e., single quotes using c#.

thilagpravin 10-Sep-12 6:21am

while am importing that into a table in db,am pass the values from csv file into a data table and later am insert those values into the specified table.when inserting that time for a particular column am removing the single quote and insert the original value.So,am not using 'sqlcommand' there.so.if u knw let me help pls..

_Amy 10-Sep-12 6:33am

Follow this[^] link. There is many techniques given on the net.
All the best.