private void frmService_Load(object sender, EventArgs e) { using (FileStream fs = new FileStream(@"service.xml", FileMode.Open, FileAccess.ReadWrite, FileShare.Read)) { XDocument xDoc = XDocument.Load(fs); List <Row> items = (from r in xDoc.Elements("DocumentElement").Elements("Row") select new Row { Servicenummer = (string)r.Element("Servicenummer") + "", Servicestalle = (string)r.Element("Servicestalle") + "", Kontaktinformation = (string)r.Element("Kontaktinformation"), Serienummer = (string)r.Element("Serienummer"), Anmalningsdatum = (string)r.Element("Anmalningsdatum"), Leveransdatum = (string)r.Element("Leveransdatum"), User = (string)r.Element("User"), Felbestrivning = (string)r.Element("Felbeskrivning"), Atgard = (string)r.Element("Atgard"), Skickad = (string)r.Element("Skickad"), Fardig = (string)r.Element("Fardig") }).ToList(); fs.SetLength(0); xDoc.Save(fs); items.ForEach(Print); var list = new BindingList <Row>(items); ListtoDataTableConverter converter = new ListtoDataTableConverter(); DataTable dt = converter.ToDataTable(list); dataGridView1.DataSource = dt; (dataGridView1.DataSource as DataTable).DefaultView.RowFilter = string.Format("Fardig LIKE '%{0}%'", "Unchecked"); } }
private void Reload() { using (FileStream fs = new FileStream(@"dataset.xml", FileMode.Open, FileAccess.ReadWrite, FileShare.Read)) { XDocument xDoc = XDocument.Load(fs); List <Row> items = (from r in xDoc.Elements("DocumentElement").Elements("Row") select new Row { ID = (string)r.Element("ID") + "", Titel = (string)r.Element("Titel") + "", Namn = (string)r.Element("Namn") + "", Klass = (string)r.Element("Klass") + "", TimeStamp = (string)r.Element("TimeStamp") + "" }).ToList(); fs.SetLength(0); xDoc.Save(fs); items.ForEach(Print); var list = new BindingList <Row>(items); ListtoDataTableConverter converter = new ListtoDataTableConverter(); DataTable dt = converter.ToDataTable(list); dataGridView1.DataSource = dt; } }
private DataTable Loader() { using (FileStream fs = new FileStream(@"produkter.xml", FileMode.Open, FileAccess.ReadWrite, FileShare.Read)) { XDocument xDoc = XDocument.Load(fs); List <Row> items = (from r in xDoc.Elements("DocumentElement").Elements("Row") select new Row { Serienummer = (string)r.Element("Serienummer") + "", Modell = (string)r.Element("Modell") + "", Marke = (string)r.Element("Marke"), Owner = (string)r.Element("Owner"), Fortackning = (string)r.Element("Fortäckning") }).ToList(); fs.SetLength(0); xDoc.Save(fs); items.ForEach(Print); var list = new BindingList <Row>(items); ListtoDataTableConverter converter = new ListtoDataTableConverter(); DataTable dt = converter.ToDataTable(list); return(dt); } }
private void KlasserSettings_Load(object sender, EventArgs e) { using (FileStream fs = new FileStream(@"klasser.xml", FileMode.Open, FileAccess.ReadWrite, FileShare.Read)) { XDocument xDoc = XDocument.Load(fs); List <Row> items = (from r in xDoc.Elements("DocumentElement").Elements("Row") select new Row { Klasser = (string)r.Element("Klasser") + "", ID = (string)r.Element("ID") + "" }).ToList(); fs.SetLength(0); xDoc.Save(fs); items.ForEach(Print); var list = new BindingList <Row>(items); ListtoDataTableConverter converter = new ListtoDataTableConverter(); DataTable dt = converter.ToDataTable(list); dataGridView1.DataSource = dt; } }
private void frmService_Load(object sender, EventArgs e) { using (var fs = new FileStream(Settings.Default.FileNameService, FileMode.Open, FileAccess.ReadWrite, FileShare.Read)) { var xDoc = XDocument.Load(fs); var items = (from r in xDoc.Elements("DocumentElement").Elements("Row") select new Row { Servicenummer = (string)r.Element("Servicenummer") + "", Servicestalle = (string)r.Element("Servicestalle") + "", Kontaktinformation = (string)r.Element("Kontaktinformation"), Serienummer = (string)r.Element("Serienummer"), Anmalningsdatum = (string)r.Element("Anmalningsdatum"), Leveransdatum = (string)r.Element("Leveransdatum"), User = (string)r.Element("User"), Felbestrivning = (string)r.Element("Felbeskrivning"), Atgard = (string)r.Element("Atgard"), Extra = (string)r.Element("Extra"), Skickad = (string)r.Element("Skickad"), Fardig = (string)r.Element("Fardig") }).ToList(); fs.SetLength(0); xDoc.Save(fs); items.ForEach(Print); var list = new BindingList <Row>(items); var converter = new ListtoDataTableConverter(); var dt = converter.ToDataTable(list); dataGridView1.DataSource = dt; var dataTable = (DataTable)dataGridView1.DataSource; if (dataTable == null) { return; } dataTable.DefaultView.RowFilter = "Fardig LIKE \'%Unchecked%\'"; } }
private DataTable Loader() { using (FileStream fs = new FileStream(@"elever.xml", FileMode.Open, FileAccess.ReadWrite, FileShare.Read)) { XDocument xDoc = XDocument.Load(fs); List <Row> items = (from r in xDoc.Elements("DocumentElement").Elements("Row") select new Row { Fornamn = (string)r.Element("Fornamn") + "", Efternamn = (string)r.Element("Efternamn") + "", Klass = (string)r.Element("Klass"), ID = (string)r.Element("ID") }).ToList(); fs.SetLength(0); xDoc.Save(fs); items.ForEach(Print); var list = new BindingList <Row>(items); ListtoDataTableConverter converter = new ListtoDataTableConverter(); DataTable dt = converter.ToDataTable(list); return(dt); } }