MySql.Data.MySqlClient.MySqlConnection conn;

        string myConnectionString =
        System.Configuration.ConfigurationManager.ConnectionStrings["db_connection1"].ConnectionString;


        conn = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
        conn.Open();
        // recupero il database attivo
        string sql = "SELECT * FROM listadb WHERE active=1";

        // comando di lettura dal database
        
        MySqlCommand cmd = new MySqlCommand(sql, conn);
        MySqlDataReader rdr = cmd.ExecuteReader();


        rdr.Read();
      
            Response.Write(rdr["nome"]);
 rdr.Close();
        conn.Close();