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))";

[647 byte] By [n9xbox] at [2008-2-27]
# 1
Hi,

Modify it to this:

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

Paul June A. Domag

PaulDomag at 2007-9-8 > top of Msdn Tech,Visual Studio Express Editions,Visual C# 2005 Express Edition...