There is an error at the following statement stating that "Syntax error at INSERT INTO statement". The code is at the below.
OleDbComm.CommandText = @"INSERT INTO Full_Blood_Count ([PatID],[PatName],[PatAge],[PatAddress],
[TDate],[TTime],[Hae],[Hae2],[Rbc],[Rbc2],
[Pcv],[Pcv2],[Mcv],[Mcv2],[Mch],[Mch2],[Mchc],[Mchc2],
[Plat],[Plat2],[Wbc],[Wbc2],[Neu],[Neu2],
[Lym],[Lym2],[Eos],[Eos2],[Mono],[Mono2],
[Bas],[Bas2],[RHae],[RRbc],[RPcv],[RMcv],[RMch],[RMchc]
[RPlat],[RWbc],[RNeu],[RLym],[REos],[RMono],[RBas])VALUES
('" + strPatID + "','" + strPatName + "','"
+ strAge + "','" + strPatAdd + "','"
+ strTestDate + "','" + strTestTime + "','"
+ dblHaemo + "','" + strHae02 + "','"
+ dblRbc + "','" + strRbc02 + "','"
+ dblPcv + "','" + strPcv02 + "','"
+ dblMcv + "','" + strMcv02 + "','"
+ dblMch + "','" + strMch02 + "','"
+ dblMchc + "','"+ strMchc02 + "','"
+ dblPlat + "','"+ strPlat02 + "','"
+ dblWbc + "','" + strWbc02 + "','"
+ dblNeu + "','" + strNeu02 + "','"
+ dblLym + "','" + strLym02 + "','"
+ dblEos + "','" + strEos02 + "','"
+ dblMono + "','" + strMono02 + "','"
+ dblBas + "','" + strBas02 + "','"
+ strRHae + "','"+ strRRbc +"','"
+ strRPcv + "','" + strRMcv + "','"
+ strRMch + "','" + strRMchc + "','"
+ strRPlat + "','" + strRWbc + "','"
+ strRNeu + "','" + strRLym + "','"
+ strREos + "','" + strRMono + "','"
+ strRBas + "')";
Please can anyone solve this!
Thank you
Chiranthaka