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.OleDb.OleDbConnection dcBUResourcesTrackingOriginal;
private System.Data.OleDb.OleDbConnection dcBUResourcesTracking;
private DataGridTableStyle dgrdTableStyle = new DataGridTableStyle();
private void btnGetData_Click(object sender, System.EventArgs e)
{
daForecast.Fill( dsResourceUsage );
}
private void btnUpdateData_Click(object sender, System.EventArgs e)
{
try
{
daForecast.Update( dsResourceUsage );
}
catch (Exception ex)
{
Console.WriteLine( ex.Message );

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

private void btnProjectView_Click(object sender, System.EventArgs e)
{
frmProjectView projectView = new frmProjectView();
projectView.ShowDialog();
}

Any suggestions/fix with regards to the "syntax error in INSERT INTO
statement" (occured when I call the btnUpdateData_Click() 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.OleDb.OleDbConnection dcBUResourcesTrackingOriginal;
private System.Data.OleDb.OleDbConnection dcBUResourcesTracking;
private DataGridTableStyle dgrdTableStyle = new DataGridTableStyle();
private void btnGetData_Click(object sender, System.EventArgs e)
{
daForecast.Fill( dsResourceUsage );
}
private void btnUpdateData_Click(object sender, System.EventArgs e)
{
try
{
daForecast.Update( dsResourceUsage );
}
catch (Exception ex)
{
Console.WriteLine( ex.Message );

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

private void btnProjectView_Click(object sender, System.EventArgs e)
{
frmProjectView projectView = new frmProjectView();
projectView.ShowDialog();
}

Any suggestions/fix with regards to the "syntax error in INSERT INTO
statement" (occured when I call the btnUpdateData_Click() 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********@hotmail.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.OleDb.OleDbConnection dcBUResourcesTrackingOriginal;
private System.Data.OleDb.OleDbConnection dcBUResourcesTracking;
private DataGridTableStyle dgrdTableStyle = new DataGridTableStyle();
private void btnGetData_Click(object sender, System.EventArgs e)
{
daForecast.Fill( dsResourceUsage );
}
private void btnUpdateData_Click(object sender, System.EventArgs e)
{
try
{
daForecast.Update( dsResourceUsage );
}
catch (Exception ex)
{
Console.WriteLine( ex.Message );

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

private void btnProjectView_Click(object sender, System.EventArgs e)
{
frmProjectView projectView = new frmProjectView();
projectView.ShowDialog();
}

Any suggestions/fix with regards to the "syntax error in INSERT INTO
statement" (occured when I call the btnUpdateData_Click() 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******@student.cs.uwaterloo.ca> wrote in message
news:Pi*******************************@cpu08.stude nt.cs.uwaterloo.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********@hotmail.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.OleDb.OleDbConnection
> dcBUResourcesTrackingOriginal;
> private System.Data.OleDb.OleDbConnection dcBUResourcesTracking;
> private DataGridTableStyle dgrdTableStyle = new DataGridTableStyle();
>
>
> private void btnGetData_Click(object sender, System.EventArgs e)
> {
> daForecast.Fill( dsResourceUsage );
> }
>
>
> private void btnUpdateData_Click(object sender, System.EventArgs e)
> {
> try
> {
> daForecast.Update( dsResourceUsage );
> }
> catch (Exception ex)
> {
> Console.WriteLine( ex.Message );
>
> Trace.WriteLine( ex.Source );
> Trace.WriteLine( ex.StackTrace );
> }
> }
>
> private void btnProjectView_Click(object sender, System.EventArgs e)
> {
> frmProjectView projectView = new frmProjectView();
> projectView.ShowDialog();
> }
>
> Any suggestions/fix with regards to the "syntax error in INSERT INTO
> statement" (occured when I call the btnUpdateData_Click() 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.