LinQ: sub items and root in DataTable
-
Hi ! I have some codes below here: DataTable objTable = new DataTable(); objTable.Columns.Add("ID"); objTable.Columns.Add("Name"); objTable.Columns.Add("Root"); DataRow objrow1 = objTable.NewRow(); objrow1["ID"] = "1"; objrow1["Name"] = "1"; objrow1["Root"] = ""; objTable.Rows.Add(objrow1); objrow1 = objTable.NewRow(); objrow1["ID"] = "11"; objrow1["Name"] = "11"; objrow1["Root"] = "1"; objTable.Rows.Add(objrow1); objrow1 = objTable.NewRow(); objrow1["ID"] = "12"; objrow1["Name"] = "12"; objrow1["Root"] = "1"; objTable.Rows.Add(objrow1); objrow1 = objTable.NewRow(); objrow1["ID"] = "121"; objrow1["Name"] = "121"; objrow1["Root"] = "12"; objTable.Rows.Add(objrow1); objrow1 = objTable.NewRow(); objrow1["ID"] = "2"; objrow1["Name"] = "2"; objrow1["Root"] = ""; objTable.Rows.Add(objrow1); objrow1 = objTable.NewRow(); objrow1["ID"] = "21"; objrow1["Name"] = "21"; objrow1["Root"] = "2"; objTable.Rows.Add(objrow1); And now, how can I list item and subitems in root is 1?Please help me !!!!:confused: