conexion.cs

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

namespace Ubar4.Datos
{
    public class Conexion
    {
        MySqlConnection conn = new MySqlConnection();
        public Conexion()
        {
            string servidor = "localhost";
            string puerto = "3306";
            string usuario = "root";
            string password = "";
            string bd = "ubar";
            string cadenaConexion = "Database=" + bd + "; Data Source=" + servidor + ";Port=" + puerto + "; User Id=" + usuario + "; Password=" + password;
            conn = new MySqlConnection(cadenaConexion);
        }
        public MySqlConnection Conectar() {
            try {
                conn.Open();
                return conn;
            } catch (Exception e) {
                MessageBox.Show("Conexion no establecida"+e.Message) ;
                return null;
            }
        }
        public bool Desconectar() {
            try
            {
                conn.Close();
                return true;
            }
            catch (Exception e) {
                MessageBox.Show("Error al cerrar la conexion"+e.Message);
                return false;
            }
        }
    }
}