using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;

namespace FsDataTest1App
{
	public partial class SiteMaster : System.Web.UI.MasterPage
	{
		protected void Page_Load(object sender, EventArgs e)
		{
			try
			{
				MySqlConnection myConnection = new MySqlConnection();
				myConnection.ConnectionString = "Server=filipstadsbacken.net.mysql.fsdata.se;Port=3306;Database=filipsta-o;Uid=filipsta;Pwd=WsPl4567;";
				myConnection.Open();
				footermessage.Text = "Database opened";
			}
			catch (MySql.Data.MySqlClient.MySqlException ex)
			{
				//footermessage.Text = ex.Message;
				switch (ex.Number)
				{
					case 0:
						footermessage.Text = "Cannot connect to server. Contact administrator";
						break;
					case 1045:
						footermessage.Text = "Invalid username/password, please try again (" + ex.Message + ")";
						break;
					default:
						footermessage.Text = ex.Number.ToString() + ", " + ex.Message;
						break;
				}
			}

		}
	}
}