MySqlUtil - TableAdapters for MySql

namespace MyqfrsDataSet_namespace
{
	public partial class FireserviceDataTable
	{
		MySqlConnection connection;
		bool connected;
		MySqlDataAdapter adapter;
		MySqlCommand deleteCommand;
		MySqlCommand insertCommand;
		MySqlCommand updateCommand;

		public bool Connect ()
		{
			connection = dataSet.NewConnection ();
			if ( connection == null )
				return false;
			InitAdapter ();
			connected = true;
			return true;
		}

		public override System.Data.DataTable Clone ()
		{
			FireserviceDataTable cln = ( (FireserviceDataTable) ( base.Clone () ) );
			cln.columnFireServiceID = base.Columns [ "FireServiceID" ];
			cln.columnName = base.Columns [ "Name" ];
			cln.columnAddress_1 = base.Columns [ "Address_1" ];
			cln.columnAddress_2 = base.Columns [ "Address_2" ];
			cln.columnTown = base.Columns [ "Town" ];
			cln.columnState = base.Columns [ "State" ];
			cln.columnPostCode = base.Columns [ "PostCode" ];
			cln.columnCommissioner = base.Columns [ "Commissioner" ];
			cln.columnPhone = base.Columns [ "Phone" ];
			return cln;
		}

		void InitAdapter ()
		{
			adapter = new MySqlDataAdapter ( "SELECT * FROM fireservice", connection );

			using ( MySqlCommandBuilder builder = new MySqlCommandBuilder ( adapter ) )
			{
				deleteCommand = builder.GetDeleteCommand ();
				insertCommand = builder.GetInsertCommand ();
				updateCommand = builder.GetUpdateCommand ();
			}

            insertCommand.Parameters [ "FireServiceID" ].Value = 0;
			insertCommand.Parameters [ "FireServiceID" ].Direction = ParameterDirection.InputOutput;
            insertCommand.Parameters [ "Name" ].Value = "QFRS";
            insertCommand.Parameters [ "Address_1" ].Value = "First Floor";
            insertCommand.Parameters [ "Address_2" ].Value = "123 Smith Street";
            insertCommand.Parameters [ "Town" ].Value = "Brisbane";
            insertCommand.Parameters [ "State" ].Value = "Queensland";
            insertCommand.Parameters [ "PostCode" ].Value = "4000";
            insertCommand.Parameters [ "Commissioner" ].Value = "Fred Nerk";
            insertCommand.Parameters [ "Phone" ].Value = "1111-1111";

			insertCommand.Connection = connection;

			object rc = insertCommand.ExecuteScalar ();

			object v = insertCommand.Parameters [ "FireServiceID" ].Value;

			FireserviceRecord rec = new FireserviceRecord ();

			rec.commissioner = "ADDED";

			this.AddFireserviceRow ( rec );

			DataTable tab = this.GetChanges ();

			if ( tab != null )
			{
				adapter.InsertCommand = null;
				adapter.Update ( tab );
			}
		}
	}
}