private void Frm_Main_Load(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();//创建LINQ to SQL数据上下文类的对象
string xmlFilePath = Application.StartupPath + "\\new.xml";//取出xml文件的全路径
//使用LINQ to XML创建XML
XDocument doc = new XDocument(
new XDeclaration("1.0", "utf-8", "yes"),
new XElement("People",
from p in dc.tb_Employee//根据LINQ to SQL取出的数据生成XML
select new XElement[]{
new XElement("Person",
new XAttribute("ID",p.ID),
new XElement("Name",p.Name),
new XElement("Sex",p.Sex),
new XElement("Age", p.Age),
new XElement("Tel",p.Tel),
new XElement("QQ",p.QQ),
new XElement("Email", p.Email),
new XElement("Address", p.Address)
)}
)
);
doc.Save(xmlFilePath);//保存XML文件
webBrowser1.Url = new Uri(xmlFilePath);//在窗体中呈现XML文件的内容
}
private void Frm_Main_Load(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();//Create LINQ to SQL datacontext object
string xmlFilePath = Application.StartupPath + "\\new.xml";//Retrieve the path of xml file
//Create the xml file
XDocument doc = new XDocument(
new XDeclaration("1.0", "utf-8", "yes"),
new XElement("People",
from p in dc.tb_Employee//Generate xml file with info get from database
select new XElement[]{
new XElement("Person",
new XAttribute("ID",p.ID),
new XElement("Name",p.Name),
new XElement("Sex",p.Sex),
new XElement("Age", p.Age),
new XElement("Tel",p.Tel),
new XElement("QQ",p.QQ),
new XElement("Email", p.Email),
new XElement("Address", p.Address)
)}
)
);
doc.Save(xmlFilePath);//Save xml file
webBrowser1.Url = new Uri(xmlFilePath);//Display content in Browser
}