Pasted

private int GetTableRows()
{
    int rows;
    using(MySqlConnection con = new MySqlConnection(CONNECTION_STRING))
    using(MySqlCommand cmd = new MySqlCommand())
    {
        con.Open();
        cmd.Connection = con;
        cmd.CommandText = "SELECT * FROM myTable";
        
        rows = int.Parse(cmd.ExecuteScaler().ToString());
    }
    
    return rows;
}