public ArrayList listar(int cod)
        {
            ArrayList arr = new ArrayList();
            string sql = "SELECT * FROM entrar where identrar='" + cod + "';";
            //string sql = "SELECT * FROM entrar where identrar like " + " @cod ";
            MySqlCommand commS = new MySqlCommand(sql, Conn.mConn);

            commS.Parameters.Add("@cod", MySqlDbType.VarChar);
            commS.Parameters["@cod"].Value = cod;

            DataTable dt = Conn.ExecuteQuery(commS);
            if (dt != null)
            {
                int i = 0;
                while (i < dt.Rows.Count)
                {
                    Usuario u = new Usuario();
                    u.Codigo = int.Parse(dt.Rows[i][0].ToString());
                    u.Login = dt.Rows[i][1].ToString();
                    u.Senha = dt.Rows[i][2].ToString();
                    u.Tipodeconta = dt.Rows[i][3].ToString();
                    u.Nomecompleto = dt.Rows[i][4].ToString();
                    u.Email = dt.Rows[i][5].ToString();
                    arr.Add(u);
                    i++;
                }
            }
            return arr;
        }
 //aqui é para listar e depois testar no login,
 public ArrayList Usuarios()
 {
     //se ele e a respectiva senha são válidos
     ArrayList arr = new ArrayList();
     string sql = "SELECT*FROM entrar;";
     MySqlCommand commS = new MySqlCommand(sql, Conn.mConn);
     DataTable dt = Conn.ExecuteQuery(commS);
     if (dt != null)
     {
         int i = 0;
         while (i < dt.Rows.Count)
         {
             Usuario u = new Usuario();
             u.Codigo = int.Parse(dt.Rows[i][0].ToString());
             u.Login = dt.Rows[i][1].ToString();
             u.Senha = dt.Rows[i][2].ToString();
             u.Tipodeconta = dt.Rows[i][3].ToString();
             u.Nomecompleto = dt.Rows[i][4].ToString();
             u.Email = dt.Rows[i][5].ToString();
             arr.Add(u);
             i++;
         }
     }
     return arr;
 }
 //serve para lista e verificar o status de ligar ou desligar no carregamento do load da tela gerais
 public ArrayList Condicaoligar()
 {
     ArrayList arr = new ArrayList();
     string sql = "SELECT * FROM configuracoes;";
     MySqlCommand commS = new MySqlCommand(sql, Conn.mConn);
     DataTable dt = Conn.ExecuteQuery(commS);
     if(dt != null)
     {
         int i = 0;
         while(i < dt.Rows.Count)
         {
             Usuario us = new Usuario();
             us.Ligar = dt.Rows[i][0].ToString();
             arr.Add(us);
             i++;
         }
     }
     return arr;
 }