如何在 c# 中从一个 mysql 表填充两个不同的数据网格

我的应用程序有问题。我正在使用WPF从一个mysql表中填充C#中的两个不同的DataGrid。

我不知道如何正确地做到这一点。下面是我的示例代码，它不起作用。 它目前只填满czesciTables，但不填czesciTables2。

我一直在研究如何做到这一点，但谷歌只向我显示来自其他来源的结果。

try
{
    for (int i = 0; i <= 4; i++ )
    {
        connection.Open();
        MySqlCommand cmd = new MySqlCommand("SELECT id_czesci_symbol AS KOD,
                                                    ilosc AS ILOSC
                                             FROM `test`.`zamowienie`
                                             WHERE z_numer_naprawy='" + numberBox.Content.ToString() + "'
                                             ORDER BY ilosc LIMIT 5;", connection);
        MySqlDataAdapter adp = new MySqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        adp.Fill(ds, "LoadDataBinding");
        czesciTable.DataContext = ds;
    }
    for (int i = 5; i <= 9; i++)
    {
        connection.Open();
        MySqlCommand cmd2 = new MySqlCommand("SELECT id_czesci_symbol AS KOD,
                                                     ilosc AS ILOSC
                                              FROM `test`.`zamowienie`
                                              WHERE z_numer_naprawy='" + numberBox.Content.ToString() + "'
                                              ORDER BY ilosc LIMIT 5;", connection);
        MySqlDataAdapter adp2 = new MySqlDataAdapter(cmd2);
        DataSet ds2 = new DataSet();
        adp2.Fill(ds2, "LoadDataBinding");
        czesciTable2.DataContext = ds2;
    }
}
catch (MySqlException ex) 
{
     MessageBox.Show(ex.ToString());
}
finally 
{
     connection.Close();
}

try
{
    for (int i = 0; i <= 9; i++ )
    {
        connection.Open();
        MySqlCommand cmd = new MySqlCommand("SELECT id_czesci_symbol AS KOD,
                                                    ilosc AS ILOSC
                                             FROM `test`.`zamowienie`
                                             WHERE z_numer_naprawy='" + numberBox.Content.ToString() + "'
                                             ORDER BY ilosc LIMIT 5;", connection);
        MySqlDataAdapter adp = new MySqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        adp.Fill(ds, "LoadDataBinding");
        if (i < 5)
            czesciTable.DataContext = ds;
        else
            czesciTable2.DataContext = ds;
        cmd.Dispose();
        adp.Dispose();
    }
}catch (MySqlException ex) {
     MessageBox.Show(ex.ToString());
}finally {
     connection.Close();
}