Common MySql Data Provider Functions

internal MySqlConnection getodbccon()
        {
            try
            {

                return new MySqlConnection(ConfigurationManager.ConnectionStrings["SpermConn"].ConnectionString);
            }
            catch (Exception ex)
            {
                // WatchDawg.CatchError(ex);
                return null;
            }
        }

        DataTable dt = new DataTable();
        internal DataTable dtexe(string query)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand(query, getodbccon());
                MySqlDataAdapter da = new MySqlDataAdapter(cmd);
                dt = new DataTable();
                da.Fill(dt);
            }
            catch
            {
                DataTable dt2 = new DataTable();
                dt2 = dt;
            }
            return dt;
        }

        

        internal DataTable dtloginexe(string query)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand(query, getodbccon());
                MySqlDataAdapter da = new MySqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                da.Fill(dt);
                return dt;
            }
            catch (Exception ex)
            {
                //WatchDawg.CatchError(ex);
                return null;
            }
        }

        internal string strscalar(string query)
        {
            try
            {
                string result = string.Empty;
                MySqlConnection con = getodbccon();
                MySqlCommand cmd = new MySqlCommand(query, con);
                con.Open();

                result = cmd.ExecuteScalar().ToString();

                con.Close();
                return result;
            }
            catch (Exception ex)
            {
                //WatchDawg.CatchError(ex);
                return string.Empty;
            }

        }

        internal int intscalar(string query)
        {
            try
            {
                int result = 0;
                MySqlConnection con = getodbccon();
                MySqlCommand cmd = new MySqlCommand(query, con);
                con.Open();

                result = Int32.Parse(cmd.ExecuteScalar().ToString());

                con.Close();
                return result;
            }
            catch (Exception ex)
            {
                // WatchDawg.CatchError(ex);
                return 0;
            }
        }
        internal void vdexe(string query)
        {
            try
            {
                MySqlConnection con = getodbccon();
                MySqlCommand cmd = new MySqlCommand(query, con);
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
            }
            catch (Exception ex)
            {
                // WatchDawg.CatchError(ex);
            }
        }