XmlDocument doc = new XmlDocument(); //创建XML操作对象
XmlElement eUsers = doc.CreateElement("Users");//生成XML根节点
doc.AppendChild(eUsers);//添加XML根节点
sql = "select * from t_users";
using (SqlConnection conn = new SqlConnection(connStr))
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
uid = reader.GetInt32(0).ToString();
uname = reader.GetString(1);
upass = reader.GetString(2);
Console.WriteLine(uid+" "+uname+" "+upass);
XmlElement eUser = doc.CreateElement("User");//添加第一个子节点,每循环一次就添加一个
eUser.SetAttribute("id", uid);
XmlElement eName = doc.CreateElement("UserName");
eName.InnerText = uname;
XmlElement ePass = doc.CreateElement("UserPass");
ePass.InnerText = upass;
eUser.AppendChild(eName);
eUser.AppendChild(ePass);
eUsers.AppendChild(eUser);
}
doc.Save(@"F:\常用工具文件(容易出错的代码都在这)\比较散的知识点(XML、集合、三层)\XMLWrite.xml");//将XML保持到指定的文件
}
}
XmlElement eUsers = doc.CreateElement("Users");//生成XML根节点
doc.AppendChild(eUsers);//添加XML根节点
sql = "select * from t_users";
using (SqlConnection conn = new SqlConnection(connStr))
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
uid = reader.GetInt32(0).ToString();
uname = reader.GetString(1);
upass = reader.GetString(2);
Console.WriteLine(uid+" "+uname+" "+upass);
XmlElement eUser = doc.CreateElement("User");//添加第一个子节点,每循环一次就添加一个
eUser.SetAttribute("id", uid);
XmlElement eName = doc.CreateElement("UserName");
eName.InnerText = uname;
XmlElement ePass = doc.CreateElement("UserPass");
ePass.InnerText = upass;
eUser.AppendChild(eName);
eUser.AppendChild(ePass);
eUsers.AppendChild(eUser);
}
doc.Save(@"F:\常用工具文件(容易出错的代码都在这)\比较散的知识点(XML、集合、三层)\XMLWrite.xml");//将XML保持到指定的文件
}
}