Error while executing sql join query from c# ADO.net

Question

I am trying to execute a simple SQL query from c# using ADO.net adapter.

Query access data from two tables using join.

Below is my code

newRequest=getrequest.selectQuery("select A.associateID, A.name, A.role, A.Salt FROM associate A INNER JOIN UserStatus UA ON UA.statusID=A.status" +
             "WHERE A.coordinatorID='"+cID+"' AND UA.statusName='WAITING FOR APPROVAL'");

con.Open();               
SqlDataAdapter sd = new SqlDataAdapter(query, con);
sd.Fill(ds);

I get error on execution:

Incorrect syntax near 'A'

I think there's a space missing in front of WHERE clause

Wudge
– Wudge

2016-11-04 08:45:52 +00:00
Commented Nov 4, 2016 at 8:45 — Wudge
– Wudge, Commented Nov 4, 2016 at 8:45
Thanks. that's a silly mistake :D

Dheeraj Kumar
– Dheeraj Kumar

2016-11-04 08:47:56 +00:00
Commented Nov 4, 2016 at 8:47 — Dheeraj Kumar
– Dheeraj Kumar, Commented Nov 4, 2016 at 8:47

Vikrant · Accepted Answer · 2016-11-04 08:47:16Z

2

Try below code:

newRequest=getrequest.selectQuery("select A.associateID, A.name, A.role, A.Salt FROM associate A " +
"INNER JOIN UserStatus UA ON UA.statusID=A.status "
"WHERE A.coordinatorID='" + cID + "' "
"AND UA.statusName='WAITING FOR APPROVAL'");

con.Open();               
SqlDataAdapter sd = new SqlDataAdapter(query, con);
sd.Fill(ds);

answered Nov 4, 2016 at 8:47

Vikrant

5,05218 gold badges53 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error while executing sql join query from c# ADO.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related