gridview not handling "OR"

G

G. Whiz

I used the wizard to create the sql statment for the gridview.
I have 2 textboxes PartNumber and PartName which I use for parameters.

I changed manually in source the AND to an OR.

SELECT* from table1WHERE ([PartNumber] = @PartNumber) or ([PartName] =
@PartName)

Yet the results show that the select statement is still treating the
statement as if it had an AND.

Help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,009
Latest member
GidgetGamb

Latest Threads

Top