<DataGrid Name="dgMusic" CanUserAddRows="false" AutoGenerateColumns="False" Margin="0,70,0,0"  ItemsSource="{Binding LoadDataBinding}" Grid.ColumnSpan="2" >
            <DataGrid.Columns>

                <DataGridTextColumn Header="Esittäjä" Binding="{Binding artist}" />
                <DataGridTextColumn Header="Albumi" Binding="{Binding album}" />
                <DataGridTextColumn Header="Kappale" Binding="{Binding title}" />

            </DataGrid.Columns>
        </DataGrid>


 string password = "";
            string connStr = "server = localhost; user = root; database = music; port = 3306; CharSet=utf8";
            MySqlConnection conn = new MySqlConnection(connStr);
            conn.Open();

            MySqlCommand cmd = new MySqlCommand("SELECT artist, album, title from songs WHERE artist LIKE '%" + textBox.Text.ToString() +"%'", conn);
            MySqlDataAdapter adp = new MySqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adp.Fill(ds, "LoadDataBinding");

            dgMusic.DataContext = ds;

            conn.Close();