MySqlUtil - TableAdapters for MySql

// Copyright (c) 2006 - Rocket Computer Services Pty Ltd
// 
// This file is part of MySqlUtil.
// 
// MySqlUtil is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// any later version.
// 
// MySqlUtil is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
// 
// You should have received a copy of the GNU General Public License
// along with Foobar; if not, write to the Free Software
// Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USAusing System;

using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Text;
using System.IO;
using System.Data;
using System.Collections.Specialized;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace MySqlDatabase
{
	/// <summary>
	/// Description of MySqlDB.
	/// </summary>
	public partial class MySqlDB
	{
		string mySqlConnectionString;
		string mySqlServer;
		string mySqlDatabaseSchema;
		string mySqlUser;
		string mySqlPassword;

		MySqlConnection mySqlConnection;
		
		bool connected = false;

		public MySqlDB()
		{
		}
		/// <summary>
		/// Connect to the MySqlServer
		/// </summary>
		/// 
		public bool Connect ( string server, string user, string password, string databaseSchema )
		{
			if ( connected )
				Close ();

			mySqlDatabaseSchema = databaseSchema;
			mySqlServer = server;
			mySqlUser = user;
			mySqlPassword = password;

			mySqlConnectionString = String.Format ( "server={0};user id={1}; password={2}; database={3}; pooling=false",
				mySqlServer, mySqlUser, mySqlPassword, mySqlDatabaseSchema );

			mySqlConnection = new MySqlConnection ( mySqlConnectionString );

			try
			{
				mySqlConnection.Open ();
			}
			catch ( MySqlException e )
			{
				MessageBox.Show ( e.Message, "MySQL Error", MessageBoxButtons.OK, MessageBoxIcon.Hand );
				return false;
			}

			connected = true;

			return true;
		}

		public void Close ()
		{
			if ( connected )
			{
				mySqlConnection.Dispose ();
				connected = false;
			}
		}

		public bool Connect ( string user, string password, string databaseSchema )
		{
			return Connect ( "", user, password, databaseSchema );
		}

		// ****************************************************************************
		// PROPERTIES
		// ****************************************************************************

		public MySqlConnection Connection
		{
			get { return mySqlConnection; }
		}

		public bool Connected
		{
			get { return connected; }
		}

		public string ConnectionString
		{
			get { return mySqlConnectionString; }
			set { mySqlConnectionString = value; }
		}
	}
}