CentralMine.NET.EventLog.ConnectToDB C# (CSharp) Method

        void ConnectToDB()
        {
            if (mSql != null)
                mSql.Close();

            string connStr = "server=localhost;user=root;database=minerdata;port=3306;password=password;";
            mSql = new MySqlConnection(connStr);
            try
            {
                mSql.Open();

                MySqlCommand cmd = new MySqlCommand("SELECT * FROM members", mSql);
                MySqlDataReader r = cmd.ExecuteReader();
                while (r.Read())
                {
                    string memberName = (string)r[1];
                    uint id = (uint)r[0];
                    mMemberIDs[memberName] = id;
                }
                r.Close();

                cmd = new MySqlCommand("SELECT * FROM products", mSql);
                r = cmd.ExecuteReader();
                while (r.Read())
                {
                    string productName = (string)r[1];
                    uint id = (uint)r[0];
                    mProductIDs[productName] = id;
                }
                r.Close();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
                mSql = null;
            }
        }