ASP.NET

in UI

 MySqlDataReader reader = businessLogic.GetRoles();

        ddRole.DataSource = reader;
        ddRole.DataBind();

In DAl


        public MySqlDataReader ExecuteReader(String query)
        {
 MySqlConnection con = new MySqlConnection((connectionString));

            MySqlCommand cmd = new MySqlCommand(query, con);

            con.Open();

            MySqlDataReader reader =cmd.ExecuteReader();

            con.Close();
            
            return reader;
     }