OledbCommand

[Christopher]

Could Anyone help me!

I'm currenly working on an application which involves SQL
Statements. And my current problem is that when i execute
the SQL statement on MS Access 2003 the Insert Statement
performs fine when i'm using OledbCommand to execute it
there would be an exception raise "Syntax Error insert
into" Why is this so?

Here is a code segment where the error occured:

public string InsertEmployee( Employee NewEmployee)
{
DailyAttendance Config DAConfig = new
DailyAttendance Config();
DataRow DRwork;
OleDbConnection Conn;
OleDbDataAdapte r OleDbAdap= new OleDbDataAdapte r();
OleDbCommand Comm;
Employee Emp = new Employee();
try
{
Conn = DAConfig.MakeCo nnection();
DRwork = NewEmployee.Tab les
[Employee.Employ eeInformationTa ble].Rows[0];
Comm = new OleDbCommand();
Comm.CommandTex t = "insert into
EmployeeInforma tion "
+ "(EmpID,Fname,L name,Mname,gend er,civilstatus, datehired,"

+"BirthDate,Tin Num,SSSNum,PagI bigNum,PhilHeal th,Spousename
,SpouseOccupati on,MaidenName,C itizenship,"
+"bloodtype,tel num,cellnum,ema iladdress,citya ddress,provin
cialaddress,fat hername,fathero ccupation,"
+ "mothername,mot heroccupation,b ankaccount,sick leave,vacat
ionleave,active ,paycode,positi on,"
+ "officeId,Basic pay) " +
"values (" + DRwork[0] + ",'" + DRwork[2] + "','"
+ DRwork[1] + "','" + DRwork[3] + "'," + DRwork[5] + ","
+ DRwork[4] + ",'" + DRwork[6] + "','" + DRwork[7]
+ "','" + DRwork[8] + "','" + DRwork[9] + "','" + DRwork
[10] + "','" + DRwork[11] + "','" + DRwork[12] +"','" +
DRwork[13] + "','" + DRwork[14] + "','" + DRwork[15]
+ "','" + DRwork[16] + "','" + DRwork[17] + "','" + DRwork
[18] + "','" + DRwork[19] + "','" + DRwork[20] + "','" +
DRwork[21] + "','" + DRwork[22] + "','" + DRwork[23]
+ "','" + DRwork[24] + "','" + DRwork[25] + "','" + DRwork
[26] + "'," + DRwork[28] + "," + DRwork[29] + ",1," +
DRwork[32] + ",'" + DRwork[31] + "'," + DRwork[30] + ","
+ DRwork[33] + ")";
Comm.Connection = Conn;
Conn.Open();
OleDbAdap.Inser tCommand = Comm;
OleDbAdap.Updat e
(NewEmployee,Em ployee.Employee InformationTabl e);
return "Success!";
}
catch (OleDbException ex)
{
return ex.Message + " - " + ex.ErrorCode.To String();
}
}

Please Help me on this

[Lennin Arriola]

set a breakpoint on line "Comm.Connectio n=..."
when code stops there, check out in the locals "Comm.CommandTe xt"
copy the SQL statement and try it on a new MSAccess Query.

that way you'll find the error easier

Lennin Arriola

"Christophe r" <ch***@mandaue. tti.com.ph> wrote in message
news:07******** *************** *****@phx.gbl.. .

Could Anyone help me!

I'm currenly working on an application which involves SQL
Statements. And my current problem is that when i execute
the SQL statement on MS Access 2003 the Insert Statement
performs fine when i'm using OledbCommand to execute it
there would be an exception raise "Syntax Error insert
into" Why is this so?

Here is a code segment where the error occured:

public string InsertEmployee( Employee NewEmployee)
{
DailyAttendance Config DAConfig = new
DailyAttendance Config();
DataRow DRwork;
OleDbConnection Conn;
OleDbDataAdapte r OleDbAdap= new OleDbDataAdapte r();
OleDbCommand Comm;
Employee Emp = new Employee();
try
{
Conn = DAConfig.MakeCo nnection();
DRwork = NewEmployee.Tab les
[Employee.Employ eeInformationTa ble].Rows[0];
Comm = new OleDbCommand();
Comm.CommandTex t = "insert into
EmployeeInforma tion "
+ "(EmpID,Fname,L name,Mname,gend er,civilstatus, datehired,"

+"BirthDate,Tin Num,SSSNum,PagI bigNum,PhilHeal th,Spousename
,SpouseOccupati on,MaidenName,C itizenship,"
+"bloodtype,tel num,cellnum,ema iladdress,citya ddress,provin
cialaddress,fat hername,fathero ccupation,"
+ "mothername,mot heroccupation,b ankaccount,sick leave,vacat
ionleave,active ,paycode,positi on,"
+ "officeId,Basic pay) " +
"values (" + DRwork[0] + ",'" + DRwork[2] + "','"
+ DRwork[1] + "','" + DRwork[3] + "'," + DRwork[5] + ","
+ DRwork[4] + ",'" + DRwork[6] + "','" + DRwork[7]
+ "','" + DRwork[8] + "','" + DRwork[9] + "','" + DRwork
[10] + "','" + DRwork[11] + "','" + DRwork[12] +"','" +
DRwork[13] + "','" + DRwork[14] + "','" + DRwork[15]
+ "','" + DRwork[16] + "','" + DRwork[17] + "','" + DRwork
[18] + "','" + DRwork[19] + "','" + DRwork[20] + "','" +
DRwork[21] + "','" + DRwork[22] + "','" + DRwork[23]
+ "','" + DRwork[24] + "','" + DRwork[25] + "','" + DRwork
[26] + "'," + DRwork[28] + "," + DRwork[29] + ",1," +
DRwork[32] + ",'" + DRwork[31] + "'," + DRwork[30] + ","
+ DRwork[33] + ")";
Comm.Connection = Conn;
Conn.Open();
OleDbAdap.Inser tCommand = Comm;
OleDbAdap.Updat e
(NewEmployee,Em ployee.Employee InformationTabl e);
return "Success!";
}
catch (OleDbException ex)
{
return ex.Message + " - " + ex.ErrorCode.To String();
}
}

Please Help me on this

[Christopher Tanchan]

Lennin,

I already done that the SQL Statement executed well no problem was
found. i know the statement has the correct syntax. i don't know why
that error came out.

This is just the first time i had this problem since i had program with
net

Thanx

Chris
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!