更新Access数据库

任何帮助将不胜感激!!



c＃新手，并尝试做一些基本的数据库编辑/更新/添加等。



似乎无法将任何数据更新到我的表格中。

我正在获取数据并能够显示和逐步通过。好像某个地方有一个只读属性!!!

Any help would be appreciated!!

New to c# and trying to do some basic database edit / update / add etc.

Cant seem to get any data to update into my table.
I am picking up the data and able to display and step thru. Its as if there is a read only attribute somewhere !!!

private void button1_Click(object sender, EventArgs e)
        {
            string connectionString = dbProvider + dbSource;
            string queryString=sql;
            DataSet dataSet = new DataSet();
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                connection.Open();
                OleDbDataAdapter adapter = new OleDbDataAdapter();
                adapter.SelectCommand = new OleDbCommand(queryString, connection);
                OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
                adapter.Fill(dataSet);

                string st = "Dizzy blond";

                dataSet.Tables[0].Rows[1].ItemArray[2] = st;

                // Code to Modify

                adapter.UpdateCommand = builder.GetUpdateCommand();
                adapter.Update(dataSet);
            }