How can I show a selected part of an xml in a DataGridView?

Question

Hi I read an XML into an dataset and show it in two dataGridViews. I coded a very small version of that xml into the code below. In datagridview1 i show the Groups and in datagridview2 i show the items. I want to show only the items from the group selected in datagridview1 (e.g. Items I1 and I2 if i click on Group1). Can someon help me to get my code working as desired? Here is my actually code: private void Form1_Load(object sender EventArgs e) { DataSet set1 = new DataSet(); string testXml =   +   +   +  Group1  +  11  +  12  +   +   +  Group2  +  21  +   +  ; StringReader reader = new StringReader(testXml); set1.ReadXml(reader); DataTableCollection tables = set1.Tables; DataView view1 = new DataView(tables[0]); DataView view2 = new DataView(tables[1]); DataGridView datagridview1 = new DataGridView(); DataGridView datagridview2 = new DataGridView(); datagridview1.SetBounds(100 100 200 400); datagridview2.SetBounds(400 100 200 400); this.Controls.Add(datagridview1); this.Controls.Add(datagridview2); BindingSource source1 = new BindingSource(); source1.DataSource = view1; datagridview1.DataSource = source1; BindingSource source2 = new BindingSource(); source2.DataSource = view2; datagridview2.DataSource = source2; // source2.Filter = Group_ID = 0; // shows only items from Group1 (i1i2) }

brunda k · Answer

DataSet set1 = new DataSet(); string fileName = data.xml; XPathExpression expr; DataGridView datagridview1 = new DataGridView(); DataGridView datagridview2 = new DataGridView(); public Form1() { InitializeComponent(); datagridview1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(datagridview1_CellContentClick); //datagridview1.SelectionChanged += new EventHandler(datagridview1_SelectionChanged); datagridview1.SetBounds(100 100 200 400); datagridview2.SetBounds(400 100 200 400); this.Controls.Add(datagridview1); this.Controls.Add(datagridview2); } private void Form1_Load(object sender EventArgs e) { try { XPathDocument doc = new XPathDocument(fileName); XPathNavigator nav = doc.CreateNavigator(); expr = nav.Compile(/Groups/Group/Name); XPathNodeIterator iterator = nav.Select(expr); DataTable dt = new DataTable(); dt.Columns.Add(Groupstypeof(string)); while (iterator.MoveNext()) { XPathNavigator nav2 = iterator.Current.Clone(); dt.Rows.Add(nav2.Value); } BindingSource source1 = new BindingSource(); source1.DataSource = dt; datagridview1.DataSource = source1; } catch (Exception ex) { Console.WriteLine(ex.Message); } } private void datagridview1_CellContentClick(object sender DataGridViewCellEventArgs e) { try { string value = datagridview1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); XPathDocument doc = new XPathDocument(fileName); XPathNavigator nav = doc.CreateNavigator(); expr = nav.Compile(/Groups/Group[Name=' + value + ']/Item); XPathNodeIterator iterator = nav.Select(expr); DataTable dt = new DataTable(); dt.Columns.Add(Item typeof(string)); while (iterator.MoveNext()) { XPathNavigator nav2 = iterator.Current.Clone(); dt.Rows.Add(nav2.Value); } BindingSource source1 = new BindingSource(); source1.DataSource = dt; datagridview2.DataSource = source1; } catch (Exception ex) { Console.WriteLine(ex.Message); } }

Hans Klose · Answer

Thanks with your solution only the Items of the selected group are shown. But if I change or add a new Items in datagridview2 it disapears when I change to an other group and then come back to the group where the Item changed/added before. Also before I could write the changed data back to xml with set1.WriteXml(filePath);