SQL help

I copied my sql query from access and it looks like this

"SELECT CalSTD.[Lab.ID]
FROM CalSTD
WHERE (((CalSTD.Element)="Al") AND ((CalSTD.[Nominal Conc])="1000"));"

My problem is, I can't get this into a string that OleDbDataAdapter likes.

I tested this in access so I know there is data returned.
My error message is "No value given for one or more required parameters".

My string = "select LabID from CalSTD where((Element = Al) and (Normial Conc = 1000))";

Answer this question

SQL help

KyleHenly
Hi,

Modify it to this:

My string = "select LabID from CalSTD where Element = 'Al' and [Normial Conc] = 1000";

cheers,

Paul June A. Domag
SQL help

Answer this question

SQL help

Hot Topic

VS Express Editions

SQL help

SQL help

KyleHenly