SqlQuery(statement,params)

Question

I wonder how to do:

params= new object[]{ new SqlParameter("ID",val),new SqlParameter("Label","'%Name%'")};
statement = "Select ID, Label from Country Where ID = ? or or Label Like ?";

I tried and it gave me :

Incorrect syntax near '?'.

Answer 1

You have a typo:

"Select ID, Label from Country Where ID = ? or or Label Like ?";

should be

"Select ID, Label from Country Where ID = ? or Label Like ?";