//////////////////////////////ArtistListDropDownList////////////////////////////
    protected void ArtistListDropDownList_SelectedIndexChanged(object sender, EventArgs e)
    {
        ServiceReference.ShowInfo artists = new ServiceReference.ShowInfo();

        ArtistListDropDownList.DataSource = artists;
        ArtistListDropDownList.DataBind();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            List <string> artits = frg.GetAllArtists().ToList();
            ArtistListDropDownList.DataSource = artits;
            ArtistListDropDownList.DataBind();

            List <string> shows = frg.GetAllShows().ToList();
            ShowNameDropDownList.DataSource = shows;
            ShowNameDropDownList.DataBind();
        }
    }