C# (CSharp) Types.DepartamentosType 예제들

예제 #1

파일: DepartamentoDAL.cs 프로젝트: paulocoliver/projeto-elvis

 public Types.DepartamentosType select()
 {
     MySqlConnection con = new MySqlConnection(Dados.StringConexao);
     string SQL = "SELECT * FROM DEPARTAMENTO";
     MySqlCommand cmd = new MySqlCommand(SQL, con);
     con.Open();
     MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
     Types.DepartamentosType types = new Types.DepartamentosType();
     while (dr.Read())
     {
         Types.DepartamentoType type = new Types.DepartamentoType();
         type.Descricao = dr["DESCRICAO"].ToString();
         type.IdDepartamento = Int32.Parse(dr["ID_DEPARTAMENTO"].ToString());
         types.Add(type);
     }
     return types;
 }

예제 #2

        public Types.DepartamentosType select()
        {
            MySqlConnection con = new MySqlConnection(Dados.StringConexao);
            string          SQL = "SELECT * FROM DEPARTAMENTO";
            MySqlCommand    cmd = new MySqlCommand(SQL, con);

            con.Open();
            MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            Types.DepartamentosType types = new Types.DepartamentosType();
            while (dr.Read())
            {
                Types.DepartamentoType type = new Types.DepartamentoType();
                type.Descricao      = dr["DESCRICAO"].ToString();
                type.IdDepartamento = Int32.Parse(dr["ID_DEPARTAMENTO"].ToString());
                types.Add(type);
            }
            return(types);
        }