C#

namespace ProjectLab1
{
    class Program
    {
        static void Main(string[] args)
        {
            //Connection string needed to talk to Omnymbus
            string conString = "Driver={MySQL ODBC 5.3 ANSI Driver};"
                + "Server=devry.edupe.net;Port=4300;"
                + "Database=Inventory_XXXX;"
                + "uid=XXXX;pwd=DeVry_Student";
            OdbcConnection connection = new OdbcConnection(conString);
            connection.Open();
            //Get all data
            //string theQuery = "SELECT * FROM item";
            string theQuery = "SELECT * FROM item i, inventory v where i.invent_id=v.invent_id";
            OdbcDataAdapter DataAdapter = new OdbcDataAdapter(theQuery, connection);
            DataSet theData = new DataSet();
            DataAdapter.Fill(theData, "item");
            DataTable theTable = theData.Tables[0];

            Console.Write("ITEM".PadRight(30));
            Console.Write("QUANT".PadLeft(10));
            Console.Write("SIZE".PadLeft(10));
            Console.Write("COLOR".PadLeft(10));
            Console.Write("PRICE\n".PadLeft(10));//the "\n" moves cursor to next line
            Console.WriteLine("-".PadLeft(70, '-'));// "WriteLine" places cursor next line

            // Loop through all data results
            foreach (DataRow dataRow in theTable.Rows)
            {
                Console.Write(dataRow["invent_desc"].ToString().PadRight(30));
                Console.Write(dataRow["qoh"].ToString().PadLeft(10));
                Console.Write(dataRow["itemsize"].ToString().PadLeft(10));
                Console.Write(dataRow["color"].ToString().PadLeft(10));
                Console.WriteLine(((decimal)dataRow["curr_price"]).ToString("C").PadLeft(10));

            }

            {



                StreamWriter file = new StreamWriter(@"C:\Users\redfaction\Desktop\Data\" + strFileName);
                file.WriteLine(sb.ToString());
                File.Close();
                connection.Close(); // Close connection

                //Have program pause to keep from closing console window



            }
        }
    }
}

try
 {
personTableAdapter.Insert(aFirstName.Text, aSurname.Text, Convert.ToDateTime(aDoB.Text), aPhone.Text, aAdd1.Text, aAdd2.Text, aSuburb.Text, aState.Text, aPostcode.Text, AdminType.Text);

administrationTableAdapter.Insert(Convert.ToInt32(aAID1.Text), aRole.Text, aPassword.Text);
MessageBox.Show(aFirstName.Text + " " + aSurname.Text + " has been added. Your ID is " + aAID1.Text);

this.personTableAdapter.Fill(this._30002195DataSet.Person);

this.administrationTableAdapter.Fill(this._30002195DataSet.Administration);

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

try
            {
                personTableAdapter.Delete(Convert.ToInt32(aID.Text), aFirstName.Text, aSurname.Text, Convert.ToDateTime(aDoB.Text), aPhone.Text, aAdd1.Text, aAdd2.Text, aSuburb.Text, aState.Text, aPostcode.Text, AdminType.Text);
                administrationTableAdapter.Delete(Convert.ToInt32(aAID.Text), aRole.Text, aPassword.Text);
                MessageBox.Show("Person Deleted");
                this.personTableAdapter.Fill(this._30002195DataSet.Person);
                this.administrationTableAdapter.Fill(this._30002195DataSet.Administration);

            }
            catch (Exception)
            {
                MessageBox.Show("Cannot delete Person");
            }

personTableAdapter.Update(aFirstName.Text, aSurname.Text, Convert.ToDateTime(aDoB.Text), aPhone.Text, aAdd1.Text, aAdd2.Text, aSuburb.Text, aState.Text, aPostcode.Text, AdminType.Text, Convert.ToInt32(aID.Text), aFirstName.Text, aSurname.Text, Convert.ToDateTime(aDoB.Text), aPhone.Text, aAdd1.Text, aAdd2.Text, aSuburb.Text, aState.Text, aPostcode.Text, AdminType.Text);
                administrationTableAdapter.Update(aRole.Text, aPassword.Text, Convert.ToInt32(aAID.Text), aRole.Text, aPassword.Text);
                

                personBindingSource.EndEdit();
                administrationBindingSource.EndEdit();
                administrationTableAdapter.Update(_30002195DataSet.Administration);
                personTableAdapter.Update(_30002195DataSet.Person);
                MessageBox.Show("Person Updated");

                this.personTableAdapter.Fill(this._30002195DataSet.Person);
                this.administrationTableAdapter.Fill(this._30002195DataSet.Administration);

personTableAdapter.Update(aFirstName.Text, aSurname.Text, Convert.ToDateTime(aDoB.Text), aPhone.Text, aAdd1.Text, aAdd2.Text, aSuburb.Text, aState.Text, aPostcode.Text, AdminType.Text, Convert.ToInt32(aID.Text), aFirstName.Text, aSurname.Text, Convert.ToDateTime(aDoB.Text), aPhone.Text, aAdd1.Text, aAdd2.Text, aSuburb.Text, aState.Text, aPostcode.Text, AdminType.Text);

administrationTableAdapter.Update(aRole.Text, aPassword.Text, Convert.ToInt32(aAID.Text), aRole.Text, aPassword.Text);

this.Validate();
                personBindingSource.EndEdit();
                teacherBindingSource.EndEdit();

                _30002195DataSet.PersonDataTable deletedPerson = (_30002195DataSet.PersonDataTable)
                    _30002195DataSet.Person.GetChanges(DataRowState.Deleted);

                _30002195DataSet.PersonDataTable newPerson = (_30002195DataSet.PersonDataTable)
                    _30002195DataSet.Person.GetChanges(DataRowState.Added);

                _30002195DataSet.PersonDataTable modifiedPerson = (_30002195DataSet.PersonDataTable)
                _30002195DataSet.Person.GetChanges(DataRowState.Modified);

                try
                {
                    if (deletedPerson != null)
                    {
                        personTableAdapter.Update(deletedPerson);
                    }

                    teacherTableAdapter.Update(_30002195DataSet.Teacher);

                    if (newPerson != null)
                    {
                        personTableAdapter.Update(newPerson);
                    }

                    if (modifiedPerson != null)
                    {
                        personTableAdapter.Update(modifiedPerson);
                    }
                    _30002195DataSet.AcceptChanges();
                }
                catch (System.Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                finally
                {
                    if (deletedPerson != null)
                    {
                        deletedPerson.Dispose();
                    }
                    if (newPerson != null)
                    {
                        newPerson.Dispose();
                    }
                    if (modifiedPerson != null)
                    {
                        modifiedPerson.Dispose();
                    }
                    MessageBox.Show("Updated");
                    this.personTableAdapter.Fill(this._30002195DataSet.Person);
                    this.teacherTableAdapter.Fill(this._30002195DataSet.Teacher);
                }

//After InitializeComponent()
SystemEvents.UserPreferenceChanging += new UserPreferenceChangingEventHandler(SessionEnded);

static void SessionEnded(object sender, UserPreferenceChangingEventArgs e)
{  
//action
}