sql string cannot executed in C

Question

0.00/5 (No votes)

See more:

hi everyone...

let me explain what im doing...

1. read a csv file..
2. store in sql...
3. if the csv file changed@updated..then read again and store in sql

issue..

in my database..im using 3 PK ..which (L_DateTime for date, L_direction for string, L_CardID for string and L_GateID for integer)

so..when step 1 executed..there will be data in db..
when step 3 executed..i need to check for validity of PK first(this is my actual problem) and merge it into db...

im using merge command in c#..but it returns error...

this is my sample of code..

VB

string mergeSql = "merge into logDetail as Target " +
                                 "using #templogDetail as Source " +
"on " +
"Target.L_DateTime=Source.L_DateTime, " +                                                "Target.L_Direction=Source.L_Direction, " +                                                 "Target.L_CardID=Source.L_CardID " + "when matched then " +
"update set Target.L_GateID=Source.L_GateID " +"when not matched then " +
"insert (L_DateTime,L_Direction,L_CardID,L_GateID) " +                                     "values(Source.L_DateTime,Source.L_Direction,Source.L_CardID,Source.L_GateID);";

                               cmd.CommandText = mergeSql;
                               cmd.ExecuteNonQuery();

the debugger said : Incorrect syntax " , " at system.data.sqlclient

guide me friendo!

Posted 23-Dec-11 19:22pm

beh7606

Add a Solution

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)

OriginalGriff · Accepted Answer · 2011-12-23T21:23:00

Solution 1

The ON clause is a single condition - I suspect you want to replace the commas with AND or OR operators.

Posted 23-Dec-11 21:23pm

OriginalGriff

Comments

Wendelius 24-Dec-11 3:46am

You beat me to it, 5 :)

beh7606 24-Dec-11 7:14am

both of you rocks! thanks...this is my first time application actually...thanks for your time ORiginalGriff...merry xmas..hohoho..

OriginalGriff 24-Dec-11 7:27am

You're welcome - have a good holiday!

Wendelius · Accepted Answer · 2011-12-23T21:26:00

In the search condition use AND instead of commas. Also it is easier to read the statements if you use @ quoted literals. So perhaps something like:

C#

string mergeSql = @"
merge into logDetail as Target 
   using #templogDetail as Source
      on Target.L_DateTime=Source.L_DateTime
      and Target.L_Direction=Source.L_Direction
      and Target.L_CardID=Source.L_CardID 
when matched then
   update set Target.L_GateID=Source.L_GateID 
when not matched then
   insert (L_DateTime,L_Direction,L_CardID,L_GateID)
   values(Source.L_DateTime,Source.L_Direction,Source.L_CardID,Source.L_GateID);";