C#

//PLEASE NOTE. ALL CONNECTION CODE AND TABLE DISPLAY IN DATA GRID WORKS FINE. CAN JUST<br />
//SKIP TO //############################ to SEE PROBLEM CODE. ALL CODE ADDED FOR CLARITY.<br />
//ALSO I DO NOT CLAIM THIS CODE TO BE DESIGNED BY ME I HAVE GRATEFULLY USED MANY <br />
//TUTORIALS AND QUESTIONS ON THE INTERNET TO COBBLE IT TOGETHER!<br />
<br />
using System;<br />
using System.Collections.Generic;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Drawing;<br />
using System.Text;<br />
using System.Windows.Forms;<br />
using System.Data.Odbc;<br />
<br />
<br />
<br />
namespace CannotUpdateTables<br />
{<br />
<br />
//This program takes the parts from my application code that are not working. The form simply has a<br />
//few text boxes on it which have the connection data in them, a button called btnUpdate, a //datagrid and and larger txt field that displays information to the user using AppendText("").<br />
<br />
    public partial class Form1 : Form<br />
    {<br />
<br />
        //Variable OBDC Objects that control the OBDC connection<br />
        private System.Data.Odbc.OdbcConnection OdbcCon;<br />
<br />
        private System.Data.Odbc.OdbcDataAdapter DataAdapter;<br />
        private DataSet DataSET;<br />
<br />
        //This Holds are connection String is neater than sending it<br />
        //the overload<br />
        private string ConStr;<br />
       <br />
<br />
        public Form1()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
        private void Form1_Load(object sender, EventArgs e)<br />
        {<br />
            <br />
//Pull Connection String from the Input Boxes, Table in MySQL Server is called "Paterson"<br />
<br />
//CONNECTION INFO STORED IN TEXT BOXES  <br />
ConStr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" + txtIP.Text + ";PORT=" + txtPort.Text + ";DATABASE=" + txtDatabase.Text + ";UID=" + txtUsername.Text + ";PWD=" + txtPassword.Text + ";OPTION=3";<br />
<br />
            //Create the ODBC Connection<br />
            OdbcCon = new System.Data.Odbc.OdbcConnection(ConStr);<br />
<br />
             //NOW TRY AND CONNECT TO THE DATABASE AND DISPLAY IT IN TABLE<br />
            try<br />
            {<br />
                //UPDATE THE TEXT LOG BOX<br />
                txtLog.AppendText("Openning connection...\r\n");<br />
                //Only Open the connection if the connection is closed<br />
                if (OdbcCon.State == ConnectionState.Closed)<br />
                {<br />
                    OdbcCon.Open();<br />
                }<br />
                //Update Log<br />
                txtLog.AppendText("Connection opened\r\n");<br />
           <br />
<br />
<br />
            //Create data adapter to select all fields from the table selected<br />
            DataAdapter = new System.Data.Odbc.OdbcDataAdapter("SELECT * FROM Paterson", OdbcCon);<br />
            //Table in MySQL server is called paterson<br />
<br />
<br />
            DataSET = new DataSet("TableData"); //Link up the data set and name the data set<br />
           <br />
<br />
            DataAdapter.Fill(DataSET);                     //Fill in the Data Adapter with the data set<br />
<br />
<br />
            //Now attach this dataset to the table<br />
            dataGrid.DataSource = DataSET.DefaultViewManager;<br />
<br />
<br />
        }<br />
<br />
<br />
        //Catch an error and display results<br />
        catch (System.Data.Odbc.OdbcException Ex)<br />
        {<br />
            txtLog.AppendText(Ex.Message + "\r\n");<br />
            MessageBox.Show("Could not access the database and Display Table.\r\nPlease make sure you completed the fields with the correct information and try again.\r\n\r\nMore details:\r\n" + Ex.Message, "Database connection error", MessageBoxButtons.OK, MessageBoxIcon.Error);<br />
        }<br />
<br />
<br />
        <br />
<br />
        }<br />
<br />
//################################################################################################<br />
//THIS IS THE BUTTON CLICK CODE<br />
        private void btnUpdate_Click(object sender, EventArgs e)<br />
        {<br />
            try<br />
            {<br />
<br />
                //HERE IS WHERE THE PROBLEM LIES, IT SIMPLY WILL NOT UPDATE THE TABLE<br />
                DataAdapter.TableMappings.Add("Paterson", "TableData");<br />
                DataAdapter.Update(DataSET, "Paterson");<br />
                DataAdapter.TableMappings.RemoveAt("Paterson");<br />
<br />
                txtLog.AppendText("Table Paterson successfully Updated\r\n");<br />
            }<br />
            catch<br />
            {<br />
                txtLog.AppendText("Table Unable to Update\r\n");<br />
            }<br />
        }<br />
<br />
//################################################################################################<br />
        }<br />
    }

DataAdapter.TableMappings.Add("Paterson", "TableData");<br />
      DataAdapter.Update(DataSET, "Paterson");<br />
      DataAdapter.TableMappings.RemoveAt("Paterson");<br />