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()); } }