1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:

<?xml version="1.0"?>
<Servicelist>
  <Favoritelist>
    <FavoriteGroup>
      <Name>Gruppe1</Name>
      <ServiceType>TV</ServiceType>
      <ChannelNo>1</ChannelNo>
      <ChannelNo>2</ChannelNo>
      <ChannelNo>3</ChannelNo>
    </FavoriteGroup>
    <FavoriteGroup>
      <Name>Gruppe2</Name>
      <ServiceType>TV</ServiceType>
      <ChannelNo>4</ChannelNo>
      <ChannelNo>5</ChannelNo>
      <ChannelNo>6</ChannelNo>
    </FavoriteGroup>
    <FavoriteGroup>
      <Name>Gruppe3</Name>
      <ServiceType>TV</ServiceType>
    </FavoriteGroup>
    <FavoriteGroup>
      <Name>Gruppe4</Name>
      <ServiceType>Radio</ServiceType>
      <ChannelNo>101</ChannelNo>
      <ChannelNo>102</ChannelNo>
      <ChannelNo>103</ChannelNo>
    </FavoriteGroup>
    <FavoriteGroup>
      <Name>Gruppe5</Name>
      <ServiceType>Radio</ServiceType>
      <ChannelNo>104</ChannelNo>
      <ChannelNo>105</ChannelNo>
      <ChannelNo>106</ChannelNo>
    </FavoriteGroup>
    <FavoriteGroup>
      <Name>Gruppe6</Name>
      <ServiceType>Radio</ServiceType>
    </FavoriteGroup>
  </Favoritelist>
</Servicelist>					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:

        private void button1_Click(object sender, EventArgs e)
        {
            string filePath = "D:\\favlist.xml";
            MyDataSet.ReadXml(filePath);

            dataGridView1.DataSource = MyDataSet;
            dataGridView1.DataMember = "FavoriteGroup";        
    
            dataGridView2.DataSource = MyDataSet;
            dataGridView2.DataMember = "ChannelNo";
        }					

1:
2:
3:
4:

BindingSource bs = new BindingSource();
bs.DataSource = MyDataSet;
dataGridView2.DataSource = bs;
dataGridView2.DataMember = "ChannelNo";					

1:
2:
3:

int rowIndex = dataGridView1.CurrentCell.RowIndex;
string sValue = dataGridView1.Rows[rowIndex].Cells[0].Value.ToString();
bs.Filter = "Name = '" + sValue + "'";					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:

        private void button1_Click(object sender, EventArgs e)
        {
            string filePath = "D:\\favlist.xml";
            MyDataSet.ReadXml(filePath);

            dataGridView1.DataSource = MyDataSet;
            dataGridView1.DataMember = "FavoriteGroup";        
    
            BindingSource bs = new BindingSource();
            bs.DataSource = MyDataSet;

            // Filterung nach Gruppe1
            bs.Filter = "Name = 'Gruppe1'";

            dataGridView2.DataSource = bs;
            dataGridView2.DataMember = "ChannelNo";
        }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:

Tabelle: Favoritelist

Favoritelist_Id
---------------
0

Tabelle: FavoriteGroup

Name    ServiceType     FavoriteGroup_Id        Favoritelist_Id
----------------------------------------------------------------
Gruppe1 TV              0                       0
Gruppe2 TV              1                       0
Gruppe3 TV              2                       0
Gruppe4 Radio           3                       0
Gruppe5 Radio           4                       0
Gruppe6 Radio           5                       0

Tabelle: ChannelNo_Text

ChannelNo_Text  FavoriteGroup_Id
--------------------------------
1               0
2               0
3               0
4               1
5               1
6               1
101             3
102             3
103             3
104             4
105             4
106             4					

1:

bs.Filter = "FavoriteGroup_Id = 0";					

1:
2:
3:

int rowIndex = dataGridView1.CurrentCell.RowIndex;
int nValue = (int)dataGridView1.Rows[rowIndex].Cells["FavoriteGroup_Id"].Value;
bs.Filter = "FavoriteGroup_Id = " + nValue;					

1:

bs.Filter = "ChannelNo_Text ='101'"					

1:
2:
3:
4:

DataTable dataTable = MyDataSet.Tables["ChannelNo_Text"]; // DataTable aus DataSet holen
DataView dataView = new DataView(dataTable); // DataView damit anlegen
dataView.RowFilter = "ChannelNo_Text ='101'"; // Filter erzeugen (heißt hier RowFilter anstatt nur Filter - bedeutet aber das gleiche ;-)
dataGridView.DataSource = dataView;					

1:
2:
3:
4:
5:

            DataTable dataTable = MyDataSet.Tables["ChannelNo"]; // DataTable aus DataSet holen  ;  ChannelNo statt ChannelNo_Text dann funktioniert es
            dataViewChannels = new DataView(dataTable); // DataView damit anlegen
            //dataView.RowFilter = "ChannelNo_Text ='101'"; // funktioniert
            dataViewChannels.RowFilter = "FavoriteGroup_ID = 1"; // testweise nach erster Gruppe filtern funktioniert auch
            dataGridView2.DataSource = dataViewChannels;					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:

        private void dataGridView1_SelectionChanged(object sender, EventArgs e)
        {
            if (dataViewChannels != null)
            {
                int rowIndex = dataGridView1.CurrentCell.RowIndex;
                // int nValue = (int)dataGridView1.Rows[rowIndex].Cells["FavoriteGroup_Id"].Value;  // funktioniert nicht da Cells["FavoriteGroup_Id"] nicht gefunden wird
                                                                                                    // es gibt nur Cells[0] "Name" und Cells[1] "ServiceType" 
                int nValue = (int)MyDataSet.Tables["FavoriteGroup"].Rows[rowIndex].ItemArray.ElementAt(2); // ElementAt(0) ist Name
                                                                                                           // ElementAt(1) ist ServiceType
                                                                                                           // ElementAt(2) ist FavoriteGroup_Id
                                                                                                           // ElementAt(3) ist FavoriteList_Id 
                dataViewChannels.RowFilter = "FavoriteGroup_ID = " + nValue;
            }
        }					

1:

dataViewChannels.Table.Columns[1].DefaultValue = nValue;					

1:

dataViewChannels.Table.Rows[0].ItemArray[0] = "100";					

1:

dataViewChannels.Table.Rows[0][0] = "100";