Updating Database with DataAdapter.Update Method

Question

Hello, I have imported a ms access database into ms visual c# 2008, it read the fields in the database, but when updating it only updates the dataset and not the actual database,

function code

    System.Data.OleDb.OleDbDataAdapter da;

 private void button2_Click(object sender, EventArgs e)
 {
        System.Data.OleDb.OleDbCommandBuilder cb;
        cb = new System.Data.OleDb.OleDbCommandBuilder(da);

        DataRow dRow = ds1.Tables["ever"].NewRow();

        dRow[1] = textBox1.Text;
        dRow[2] = textBox1.Text;
        dRow[3] = textBox1.Text;

        ds1.Tables["ever"].Rows.Add(dRow);

        da.Update(ds1, "ever");

        MessageBox.Show("Record added");
    }

but error of

"The ConnectionString property has not been initialized."

at code :

da.Update(ds1, "ever");

thanks

Answer 1

is there a commit instruction in c# ms access library?

Answer 2

The Update method uses the command you specify in the UpdateCommand property. I suspect that is part of your problem. There is probably a similar property for the connection string for each of the commands (SELECT, INSERT, UPDATE, DELETE).