How Can I Make My Drop-Down List Print Information From Database Into A Label. C#

protected void venInfoDDL_SelectedIndexChanged1(object sender, EventArgs e)
       {
           //Creating a select statement that searches for record that matchs VenueID from Value property.
           string venInfoSelectSql;
           venInfoSelectSql = "SELECT * FROM Venue";
           venInfoSelectSql += "WHERE VenueID = '" + venInfoDDL.SelectedItem.Value + "'";

           //defining the ADO.NET objects.
           SqlConnection conB1 = new SqlConnection(adminCon);
           SqlCommand cmdB1 = new SqlCommand(venInfoSelectSql, conB1);
           SqlDataReader readerB1;

           //Opening database and reading information.
           try
           {
               conB1.Open();
               readerB1 = cmdB1.ExecuteReader();
               readerB1.Read();

               //building a string with the record information and displaying in label.
               StringBuilder venInfoSB = new StringBuilder();
               venInfoSB.Append("<b>");
               venInfoSB.Append(readerB1["UserName"]);
               venInfoSB.Append("</b><br/>");
               venInfoSB.Append("VenueID:");
               venInfoSB.Append(readerB1["VenueID"]);
               venInfoSB.Append("<br>");
               venInfoSB.Append("Manager:");
               venInfoSB.Append(readerB1["VenueManager"]);
               venInfoSB.Append("<br/>");
               venInfoSB.Append("Email:");
               venInfoSB.Append(readerB1["VenueEmail"]);
               venInfoSB.Append("<br/>");
               venInfoSB.Append("Phone:");
               venInfoSB.Append(readerB1["VenueTelephoneNumber"]);
               venInfoSB.Append("<br/>");
               venInfoLabel.Text = venInfoSB.ToString();

           }
           catch (Exception err)
           {
               venInfoLabel.Text = "Error getting Venue";
               venInfoLabel.Text += err.Message;
           }
           finally
           {
               conB1.Close();
           }

       }

protected void artInfoDDL_SelectedIndexChanged1(object sender, EventArgs e)
        {
            //Creating Select statement that searches for a record that matches ArtistID from Value property.
            string artInfoSelectSql;
            artInfoSelectSql = "SELECT * FROM Artist";
            artInfoSelectSql += "WHERE ArtistID = '" + artInfoDDL.SelectedItem.Value + "'";

            //defining the ADO.NET objects.
            SqlConnection conC1 = new SqlConnection(adminCon);
            SqlCommand cmdC1 = new SqlCommand(artInfoSelectSql, conC1);
            SqlDataReader readerC1;

            //Opening database & reading information.
            try
            {
                conC1.Open();
                readerC1 = cmdC1.ExecuteReader();
                readerC1.Read();

                //building a string with the record information and diplaying in label.
                StringBuilder artInfoSB = new StringBuilder();
                artInfoSB.Append("<b>");
                artInfoSB.Append(readerC1["UserName"]);
                artInfoSB.Append("</b><br/>");
                artInfoSB.Append("ArtistID:");
                artInfoSB.Append(readerC1["ArtistID"]);
                artInfoSB.Append("<br/>");
                artInfoSB.Append("Contact:");
                artInfoSB.Append(readerC1["ArtistContactName"]);
                artInfoSB.Append("<br/>");
                artInfoSB.Append("Email:");
                artInfoSB.Append(readerC1["ArtistEmail"]);
                artInfoSB.Append("<br/>");
                artInfoSB.Append("Phone:");
                artInfoSB.Append(readerC1["ArtistTelNo"]);
                artInfoSB.Append("<br/>");
                artInfoLabel.Text = artInfoSB.ToString();


            }
            catch (Exception err)
            {
                artInfoLabel.Text = "Error getting Artist.";
                artInfoLabel.Text += err.Message;

            }
            finally
            {
                conC1.Close();
            }
        }