Loading

Problems with OleDbDataAdapter

Marcus Ohlsson

I have a small question, why can't I use this code?

da = New OleDbDataAdapter("Select * from Company where Aktiv=true and Cat=L order by Company", conn)

What is the right way when I have 2 "where" statements?

Best regards
Marcus

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
I don't know which database you're using but you should be able to join conditions together with the 'AND' operator in the Where clause as you've done.

However, I would expect that you'd need to surround character or string literals with single quotes, so I'd try:

da = New OleDbDataAdapter("Select * from Company where Aktiv=true and Cat='L' order by Company", conn)

Also, in your 'order by' clause, is it in fact the case that you have a column called Company within the Company table?
Marcus Ohlsson15y ago
Hello Vulpes.

First I would like to thank you for your quick respond.

You were right, I just needed the ' around "L"

Br Marcus