musicdb

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Configuration;
using System.Data.SqlClient;

namespace muziekdatabaseje13
{
    public partial class frmMain : Form
    {
        SqlConnection connection;
        string connectionString;
        public frmMain()
        {
            
            InitializeComponent();
            
            connectionString = ConfigurationManager.ConnectionStrings["muziekdatabaseje13.Properties.Settings.MuziekDBConnectionString"].ConnectionString;
            PopulateArtists();

        }
        private void frmMain_Load(object sender, EventArgs e)
        {
            
        }

        private void PopulateArtists()
        {
            using (connection = new SqlConnection(connectionString))
            using (SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Artists", connection))
            {
                DataTable artistTable = new DataTable();
                adapter.Fill(artistTable);

                listBoxArtists.DisplayMember = "ArtistName";
                listBoxArtists.ValueMember = "Info";
                listBoxArtists.DataSource = artistTable;
            }
            
        }

        private void PopulateAlbums()
        {
            string querry = "SELECT a.AlbumName FROM Albums a" +
                "INNER JOIN Artists b ON a.ArtistsId = b.ArtistsId" +
                "WHERE ArtistsId = @ArtistsId";

            using (connection = new SqlConnection(connectionString))
            using (SqlCommand command = new SqlCommand(querry, connection ))
            using (SqlDataAdapter adapter = new SqlDataAdapter(command))
            {
                command.Parameters.AddWithValue("@ArtistsId", listBoxArtists.SelectedValue);

                DataTable albumsTable = new DataTable();
                adapter.Fill(albumsTable);

                listBoxAlbums.DisplayMember = "AlbumName";
                listBoxAlbums.ValueMember = "AlbumId";
                listBoxAlbums.DataSource = albumsTable;
            }

        }
        private void listBoxArtists_SelectedIndexChanged(object sender, EventArgs e)
        {
            PopulateAlbums();


        }
    }
}