SQL query doesn't work on SQL Server

Question

I am new to web services and I have written some simple queries. They work just fine, but this one doesn't return json

SqlDataReader dr;
SqlCommand cmd = new SqlCommand("SELECT * FROM doctors WHERE address LIKE %@add%", conn);
cmd.Parameters.AddWithValue("@add", address);

dr = cmd.ExecuteReader();

If I type it like

"select * from doctors WHERE address = @add

it works fine

What seems to be the problem?

@ganeshran That won't work since @add is a parameter. The OP needs to do what Alex has. — juharr
– juharr, Commented May 8, 2017 at 13:27
You have to add the wildcards like Alex said or add them to address before creating the parameter. — juharr
– juharr, Commented May 8, 2017 at 13:29

Fran · Accepted Answer · 2017-05-08 13:30:38Z

1

Add the % to the value, not the parameter name

var address = "%1 main street%";

SqlDataReader dr;
SqlCommand cmd = new SqlCommand("SELECT * FROM doctors WHERE address LIKE @add", conn);
cmd.Parameters.AddWithValue("@add", address);
dr = cmd.ExecuteReader();

answered May 8, 2017 at 13:30

Fran

6,5801 gold badge26 silver badges37 bronze badges

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

Comments

SynozeN Technologies · Accepted Answer · 2017-05-08 13:45:07Z

0

try this

SqlDataReader dr;
SqlCommand cmd = new SqlCommand("SELECT * FROM doctors WHERE address LIKE '%@add%'", conn);
cmd.Parameters.AddWithValue("@add", address);
dr = cmd.ExecuteReader();

answered May 8, 2017 at 13:45

SynozeN Technologies

1,3431 gold badge14 silver badges19 bronze badges

Collectives™ on Stack Overflow

SQL query doesn't work on SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related