DBconnection.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace ABC_Institute___Timetable_Generator
{
    class DBconnection
    {
        private String conString = @"SERVER=abcdatabase.mysql.database.azure.com;PORT=3306;DATABASE=mydb;UID=abcadmin@abcdatabase;PASSWORD=ABC@123abc";
        private MySqlConnection con;
       
        public MySqlConnection getConnection()
        {
            try { 
            MySqlConnection con = new MySqlConnection(conString);
            this.con = con;
            this.con.Open();
            }catch(Exception e)
            {
                MessageBox.Show("Data Connection Error Occured");
            }
            return this.con;

        }
        public void closeConnection()
        {
            
            this.con.Close();
            

        }



    }
    
}