MySqlUtil - TableAdapters for MySql

/*
 * Created by SharpDevelop.
 * User: Ian Semmel
 * Date: 11/07/2006
 * Time: 4:59 AM
 */

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; }
		}
	}
}