Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Problem to update or insert any Data from C# to Access Database

shanewajshanewaj Posts: 1Member
I have created a very simple database in Access and by using DataAdapter in C#.
I can Load(View) Data in my C# front End and also can Delete Data But
when I tried to Inser or Edit there is a error, "Syntex Error into INSERT INTO ".
But I think the Syntex is ok ... I have checked the SQL command and it is bug free.

dataAdapter.InsertCommand = conn.CreateCommand();
dataAdapter.InsertCommand.CommandText =
"INSERT INTO student (StudentID,name,roll,year) VALUES(@StudentID,@name,@roll,@year)";
AddParams(dataAdapter.InsertCommand,"StudentID","name","roll","year");


I have make this program with the help of C# leasring School Leasen 13.

Comments

  • patrik66patrik66 Posts: 10Member
    : I have created a very simple database in Access and by using DataAdapter in C#.
    : I can Load(View) Data in my C# front End and also can Delete Data But
    : when I tried to Inser or Edit there is a error, "Syntex Error into INSERT INTO ".
    : But I think the Syntex is ok ... I have checked the SQL command and it is bug free.
    :
    : dataAdapter.InsertCommand = conn.CreateCommand();
    : dataAdapter.InsertCommand.CommandText =
    : "INSERT INTO student (StudentID,name,roll,year) VALUES(@StudentID,@name,@roll,@year)";
    : AddParams(dataAdapter.InsertCommand,"StudentID","name","roll","year");
    :
    :
    : I have make this program with the help of C# leasring School Leasen 13.
    :
    :

    Hi,

    I'm most certain that name are a keyword to Access, you can
    resolve this by placing square brackets around the column names
    in the insert statement like this
    "INSERT INTO Student([StudentID], [name], [roll], [year])
    VALUES( ?, ?, ?, ?)"

    Hope this helps you.

    // Patrik
  • Yepper65Yepper65 Posts: 29Member
    : : I have created a very simple database in Access and by using DataAdapter in C#.
    : : I can Load(View) Data in my C# front End and also can Delete Data But
    : : when I tried to Inser or Edit there is a error, "Syntex Error into INSERT INTO ".
    : : But I think the Syntex is ok ... I have checked the SQL command and it is bug free.
    : :
    : : dataAdapter.InsertCommand = conn.CreateCommand();
    : : dataAdapter.InsertCommand.CommandText =
    : : "INSERT INTO student (StudentID,name,roll,year) VALUES(@StudentID,@name,@roll,@year)";
    : : AddParams(dataAdapter.InsertCommand,"StudentID","name","roll","year");
    : :
    : :
    : : I have make this program with the help of C# leasring School Leasen 13.
    : :
    : :
    :
    : Hi,
    :
    : I'm most certain that name are a keyword to Access, you can
    : resolve this by placing square brackets around the column names
    : in the insert statement like this
    : "INSERT INTO Student([StudentID], [name], [roll], [year])
    : VALUES( ?, ?, ?, ?)"
    :
    : Hope this helps you.
    :
    : // Patrik
    :

    Hi,

    I've connected to a Access DB with the OleDbDataAdapter and the Adapter generated some code. Aa result i see at the top of my programm the following code when i completed also the creation of a dataSet:

    System;
    using System.Drawing;
    using System.Collections;
    using System.ComponentModel;
    using System.Windows.Forms;

    namespace WindowsUZB
    {
    ///
    /// Summary description for Arbeidsbelemmering.
    ///
    public class Arbeidsbelemmering : System.Windows.Forms.Form
    {
    private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
    private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
    private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
    private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
    private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
    private System.Data.OleDb.OleDbConnection oleDbConnection1;
    private WindowsUZB.arbeidsbelemmeringDS arbeidsbelemmeringDS1;

    When i look at the grey part in the code that will expand when i click on it,i see all the specific update and delete commands and the connection string to the database.
    So when i call the oleDbDataAdapter.Update method and fill in the name of the dataSet the actual update takes place when i push the Opslaan (Update).
    In this code "arbeidsbelemmeringenDS1"is the name of the dataSet and "arbeidsbelemmeringen" the name of the table in the database.


    private void Opslaan_Click(object sender, System.EventArgs e)
    {
    try
    {
    this.BindingContext[arbeidsbelemmeringDS1,"arbeidsbelemmering"].EndCurrentEdit();
    this.oleDbDataAdapter1.Update(arbeidsbelemmeringDS1);
    }
    catch (System.Exception eEndEdit)
    {
    System.Windows.Forms.MessageBox.Show(eEndEdit.Message);
    }

    }

    For me this code works and the data is saved in the database.

    With friendluy greatings,


    Yepper65

Sign In or Register to comment.