private void btnMostrarTodosArtistas_Click(object sender, EventArgs e)
        {
            ArtistDAL aD = new ArtistDAL();
            DataTable dt = new DataTable();

            dataGridBuscar.Columns.Add("Artista", "Artista");
            dt = aD.selectAllArtist();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dataGridBuscar.Rows.Add(dt.Rows[i].ItemArray[1].ToString());
            }
        }
        private void AlbumForm_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'chinookDataSet.Track' table. You can move, or remove it, as needed.
            //     this.trackTableAdapter.Fill(this.chinookDataSet.Track);
            ArtistDAL aD = new ArtistDAL();
            DataTable dt = new DataTable();

            dt = aD.selectAllArtist();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                cbArtistas.Items.Add(dt.Rows[i].ItemArray[1].ToString());
            }
        }