KẾT NỐI XML
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Xml;
using System.Xml.Linq;
namespace KetNoiXML
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
string path = "D:\\Test.xml";
private void Loaddata()
{
XmlDataDocument xmlsach = new XmlDataDocument();
xmlsach.DataSet.ReadXml(Application.StartupPath + "\\Demo.xml");
dtXML.DataSource = xmlsach.DataSet;
dtXML.DataMember = "student";
}
private void Form1_Load(object sender, EventArgs e)
{
Loaddata();
}
private void btnThem_Click(object sender, EventArgs e)
{
string day = DateTime.Now.Day.ToString();
string month = DateTime.Now.Month.ToString();
string year = DateTime.Now.Year.ToString();
string hour = DateTime.Now.Hour.ToString();
string minute = DateTime.Now.Minute.ToString();
string second = DateTime.Now.Second.ToString();
long id = long.Parse(day + month + year + hour + minute + second);
try
{
XDocument testXML = XDocument.Load(path);
XElement newStudent = new XElement("Student",
new XElement("Name", txtTen.Text),
new XElement("Age", txtTuoi.Text));
var lastStudent = testXML.Descendants("Student").Last();
long newID = Convert.ToInt64(lastStudent.Attribute("ID").Value);
newStudent.SetAttributeValue("ID", id);
testXML.Element("Students").Add(newStudent);
testXML.Save(path);
Loaddata();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnSua_Click(object sender, EventArgs e)
{
try
{
XDocument testXML = XDocument.Load(path);
XElement cStudent = testXML.Descendants("Student").Where(c => c.Attribute("ID").Value.Equals(txtTuoi.Text)).FirstOrDefault();
cStudent.Element("Name").Value = txtTen.Text;
cStudent.Element("Age").Value = txtTuoi.Text;
testXML.Save(path);
Loaddata();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
}
}
Chia sẻ với bạn bè của bạn: |