syntax error in INSERT INTO statement

[William]

i am using a dataset and a DataAdapter to update a table with the
following schema:
ResourceID
ProjectID
LastName
FirstName
Year
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct

i got the following error message:
syntax error in INSERT INTO statement

my code:
private System.Windows. Forms.Button btnProjectView;
private System.Data.Ole Db.OleDbConnect ion dcBUResourcesTr ackingOriginal;
private System.Data.Ole Db.OleDbConnect ion dcBUResourcesTr acking;
private DataGridTableSt yle dgrdTableStyle = new DataGridTableSt yle();
private void btnGetData_Clic k(object sender, System.EventArg s e)
{
daForecast.Fill ( dsResourceUsage );
}
private void btnUpdateData_C lick(object sender, System.EventArg s e)
{
try
{
daForecast.Upda te( dsResourceUsage );
}
catch (Exception ex)
{
Console.WriteLi ne( ex.Message );

Trace.WriteLine ( ex.Source );
Trace.WriteLine ( ex.StackTrace );
}
}

private void btnProjectView_ Click(object sender, System.EventArg s e)
{
frmProjectView projectView = new frmProjectView( );
projectView.Sho wDialog();
}

Any suggestions/fix with regards to the "syntax error in INSERT INTO
statement" (occured when I call the btnUpdateData_C lick() method) is
greatly appreciated.

William

[teddysnips]

William wrote:

i am using a dataset and a DataAdapter to update a table with the
following schema:
ResourceID
ProjectID
LastName
FirstName
Year
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct

i got the following error message:
syntax error in INSERT INTO statement

my code:
private System.Windows. Forms.Button btnProjectView;
private System.Data.Ole Db.OleDbConnect ion dcBUResourcesTr ackingOriginal;
private System.Data.Ole Db.OleDbConnect ion dcBUResourcesTr acking;
private DataGridTableSt yle dgrdTableStyle = new DataGridTableSt yle();
private void btnGetData_Clic k(object sender, System.EventArg s e)
{
daForecast.Fill ( dsResourceUsage );
}
private void btnUpdateData_C lick(object sender, System.EventArg s e)
{
try
{
daForecast.Upda te( dsResourceUsage );
}
catch (Exception ex)
{
Console.WriteLi ne( ex.Message );

Trace.WriteLine ( ex.Source );
Trace.WriteLine ( ex.StackTrace );
}
}

private void btnProjectView_ Click(object sender, System.EventArg s e)
{
frmProjectView projectView = new frmProjectView( );
projectView.Sho wDialog();
}

Any suggestions/fix with regards to the "syntax error in INSERT INTO
statement" (occured when I call the btnUpdateData_C lick() method) is
greatly appreciated.

William

Where's your code for populating the dsResourceUsage dataset? We need
SQL to work with.

Edward

[William]

SELECT ResourceID, ProjectID, LastName, FirstName, Year, Nov, Dec,
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct
FROM Forecast
On Wed, 1 Jun 2005 te********@hotm ail.com wrote:

William wrote:

i am using a dataset and a DataAdapter to update a table with the
following schema:
ResourceID
ProjectID
LastName
FirstName
Year
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct

i got the following error message:
syntax error in INSERT INTO statement

my code:
private System.Windows. Forms.Button btnProjectView;
private System.Data.Ole Db.OleDbConnect ion dcBUResourcesTr ackingOriginal;
private System.Data.Ole Db.OleDbConnect ion dcBUResourcesTr acking;
private DataGridTableSt yle dgrdTableStyle = new DataGridTableSt yle();
private void btnGetData_Clic k(object sender, System.EventArg s e)
{
daForecast.Fill ( dsResourceUsage );
}
private void btnUpdateData_C lick(object sender, System.EventArg s e)
{
try
{
daForecast.Upda te( dsResourceUsage );
}
catch (Exception ex)
{
Console.WriteLi ne( ex.Message );

Trace.WriteLine ( ex.Source );
Trace.WriteLine ( ex.StackTrace );
}
}

private void btnProjectView_ Click(object sender, System.EventArg s e)
{
frmProjectView projectView = new frmProjectView( );
projectView.Sho wDialog();
}

Any suggestions/fix with regards to the "syntax error in INSERT INTO
statement" (occured when I call the btnUpdateData_C lick() method) is
greatly appreciated.

William

Where's your code for populating the dsResourceUsage dataset? We need
SQL to work with.

Edward

[Justin Hoffman]

"William" <wh******@stude nt.cs.uwaterloo .ca> wrote in message
news:Pi******** *************** ********@cpu08. student.cs.uwat erloo.ca...

SELECT ResourceID, ProjectID, LastName, FirstName, Year, Nov, Dec,
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct
FROM Forecast
On Wed, 1 Jun 2005 te********@hotm ail.com wrote:

William wrote:

> i am using a dataset and a DataAdapter to update a table with the
> following schema:
> ResourceID
> ProjectID
> LastName
> FirstName
> Year
> Nov
> Dec
> Jan
> Feb
> Mar
> Apr
> May
> Jun
> Jul
> Aug
> Sep
> Oct
>
> i got the following error message:
> syntax error in INSERT INTO statement
>
> my code:
> private System.Windows. Forms.Button btnProjectView;
> private System.Data.Ole Db.OleDbConnect ion
> dcBUResourcesTr ackingOriginal;
> private System.Data.Ole Db.OleDbConnect ion dcBUResourcesTr acking;
> private DataGridTableSt yle dgrdTableStyle = new DataGridTableSt yle();
>
>
> private void btnGetData_Clic k(object sender, System.EventArg s e)
> {
> daForecast.Fill ( dsResourceUsage );
> }
>
>
> private void btnUpdateData_C lick(object sender, System.EventArg s e)
> {
> try
> {
> daForecast.Upda te( dsResourceUsage );
> }
> catch (Exception ex)
> {
> Console.WriteLi ne( ex.Message );
>
> Trace.WriteLine ( ex.Source );
> Trace.WriteLine ( ex.StackTrace );
> }
> }
>
> private void btnProjectView_ Click(object sender, System.EventArg s e)
> {
> frmProjectView projectView = new frmProjectView( );
> projectView.Sho wDialog();
> }
>
> Any suggestions/fix with regards to the "syntax error in INSERT INTO
> statement" (occured when I call the btnUpdateData_C lick() method) is
> greatly appreciated.
>
> William

Where's your code for populating the dsResourceUsage dataset? We need
SQL to work with.

Edward

This isn't really the right newsgroup for this question as it has almost
nothing to do with Access. The fact that it might use an mdb file is not
really relavant. The ADO.NET object model involves a DataAdapter object
which has InsertCommand, UpdateCommand and DeleteCommand properties. You
can code these yourself or use a CommandBuilder object to get them done for
you although I'm sure it helps if the table has a single field to easily
identify the primary key.