Cannot Update a database via DataGridView Control after programatically adding Columns - C#

Hello,

1. I have a Windows Form app where I am binding a DagridView to a Dataset which was filled from a SQL Server database table.

2. I then have a method to Update the database.

This all works fine but I wanted to add the columns to the DataGridView programatically in order to customize them.

Using Jim Brandleys code example, I am able to do this, add the columns programatically and view all of the data from the SQL table in my DataGridView and customize columns too.

3. Problem: My Update method no longer works. See code below&

I removed the lines to bind the dataGridView to the datSet because the compiler complain when I was programatically adding columns

//dataGridView1.DataSource = dataSet1;
//dataGridView1.DataMember = "Stats";  

I suspect that I am not properly bound to the dataSet (and SQL table) the way I am trying to update but cant see it..                    



SQL = SELECT A,B,C  FROM SQLTable
Conn = new OleDbConnection(ConStr))
cmd = new OleDbCommand(SQL, Conn)
Conn.Open();
da = new OleDbDataAdapter()
da.SelectCommand = cmd;
oleDbCb = new OleDbCommandBuilder(da)
dataSet1.Clear();
da.Fill(dataSet1, "Stats");

//note removed these two lines in order to programatically add Columns to DataGridView
//dataGridView1.DataSource = dataSet1;
//dataGridView1.DataMember = "Stats";                      

//set DataGrid Properties
dataGridView1.AutoGenerateColumns = false;
//etc
//etc                      
//call Jims AddColumns method to add columns to  attach columns to the DataGrid
 AddColumns();
                       
 //fill the grid with Object Array - The indexer is the number of columns
 Object[] cellData = new Object[4];
 DataTable dtble = dataSet1.Tables["Stats"];
 foreach (DataRow row in dtble.Rows)
 {
  //celldata adds a column, row.ItemArray adds all rows of that column
  cellData[0] = row.ItemArray[0];
  cellData[1] = row.ItemArray[1];
  dataGridView1.Rows.Add(cellData);
 }//end foreach

//Jims AddColumns() Method:
// Text Box Column only for numeric values, of type int

AddColumns
{
DataGridViewTextBoxColumn column2 = new DataGridViewTextBoxColumn();
//DataGridViewTextBoxColumn column3instance created in //Declarations
            column2.Name = "ID Number";
            column2.HeaderText = "ID Number";
            column2.Width = 48;
            column2.ValueType = typeof(int);
            cell = new DataGridViewTextBoxCell();
            column2.CellTemplate = cell;
            this.dataGridView1.Columns.Add(column2);

}//end AddColumns()

My Update() Method (This does not work now that I am programatically adding Columns to the DataGridView)

UpdateDataBase()
{
SQL = SELECT A,B,C  FROM SQLTable
OleDbConnection Conn = new OleDbConnection(ConStr);
//OleDbDataAdapter da = new OleDbDataAdapter();//in Declarations
OleDbCommandBuilder oleDbCb = new OleDbCommandBuilder(da);
Conn.Open();
OleDbTransaction trans = Conn.BeginTransaction();
cmd = new OleDbCommand(SQL, Connn)
da.SelectCommand = cmd;
cmd.Transaction = trans;
da.Update(dataSet1, "Stats");
MessageBox.Show("Your changes have persisted to the Database!");
trans.Commit();

Can anyone see what I am missing here?

Thanks