Database

<br />
DataSET.AcceptChanges();                            //Dataset linked to grid updates<br />
DataAdapter.TableMappings.Add("Test", "TableData"); //Create table mapping of remote table<br />
DataAdapter.Update(DataSET, "Test");                //Use update command of data adapter<br />
DataAdapter.TableMappings.RemoveAt("Test");         //Remove table mapping<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 "Test"<br />
<br />
//CONNECTION INFO STORED IN TEXT BOXES<br />
ConStr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" + txtIP.Text + "ORT=" + txtPort.Text + ";DATABASE=" + txtDatabase.Text + ";UID=" + txtUsername.Text + "WD=" + txtPassword.Text + ";OPTION=3";<br />
<br />
//Create the ODBC Connection<br />
OdbcCon = new System.Data.Odbc.OdbcConnection(ConStr);<br />
<br />
//NOW 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 Test", 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 />
<br />
DataSET.AcceptChanges();<br />
DataAdapter.TableMappings.Add("Test", "TableData");<br />
DataAdapter.Update(DataSET, "Test");<br />
DataAdapter.TableMappings.RemoveAt("Test");<br />
<br />
txtLog.AppendText("Table Test successfully Updated\r\n");<br />
}<br />
catch<br />
{<br />
txtLog.AppendText("Table Unable to Update\r\n");<br />
}<br />
}<br />
<br />
//################################################################################################<br />
}<br />
}