利用c#将数据库中的数据读到XML文件中
事件处理程序：
dataConn dc = new dataConn();
DataTable dt = new DataTable();
dt = dc.DataTable( "select * from userinfo ");
XmlTextWriter xtw = new XmlTextWriter( "test12.xml ", Encoding.UTF8);
xtw.Formatting = Formatting.Indented;
xtw.Indentation = 1;
xtw.IndentChar = Convert.ToChar( "\t ");
xtw.QuoteChar = Convert.ToChar( "\ " ");
xtw.WriteStartDocument();
xtw.WriteStartElement( "userInfo ");
for (int i = 0; i < dt.Rows.Count; i++)
{
xtw.WriteStartElement( "user ");
xtw.WriteAttributeString( "name ", dt.Rows[i][ "userName "].ToString());
xtw.WriteAttributeString( "password ", dt.Rows[i][ "userPassword "].ToString());
xtw.WriteEndElement();
}
xtw.WriteEndElement();
xtw.WriteEndDocument();
xtw.Close();
Application.Exit();
目标文件：
<?xml version= "1.0 " encoding= "utf-8 "?>
<userInfo>
<user name= "艾林 " password= "12517820817 " />
<user name= "艾青 " password= "12518581127 " />
<user name= "安平 " password= "12513222515 " />
<user name= "薄帆 " password= "12517344910 " />
<user name= "曹东锋 " password= "12513372119 " />
<user name= "查金祥 " password= "12511321512 " />

<user name= "陈浩 " password= "12518202217 " />
<user name= "陈静超 " password= "12519140703 " />
<user name= "陈军 " password= "12519140122 " />
<user name= "陈俊斌 " password= "12518401008 " />
<user name= "陈楠 " password= "12518371314 " />
<user name= "陈前辉 " password= "12513222811 " />
<user name= "陈文超 " password= "12511252012 " />
<user name= "陈晓明 " password= "12511321702 " />
<user name= "陈岩 " password= "12518150104 " />
<user name= "陈勇 " password= "12519141905 " />
<user name= "程慧 " password= "12518943411 " />
<user name= "迟洁超 " password= "12513359120 " />
<user name= "崔涵棋 " password= "12518260211 " />
<user name= "邓俊 " password= "12514014229 " />
<user name= "狄志军 " password= "12513222417 " />
<user name= "丁力 " password= "12518891228 " />
<user name= "东艳 " password= "12518751604 " />
<user name= "杜诗晨 " password= "12511230817 " />
</userInfo>
现在想改成这种格式的：
<userInfo>
<user password= "12517820817 "> 艾林 </user>
……
</userInfo>
请问如何更改事件处理程序。

[解决办法]
xtw.WriteStartElement( "user ");
xtw.WriteAttributeString( "password ", dt.Rows[i][ "userPassword "].ToString());
xtw.WriteString(dt.Rows[i][ "userName "].ToString());
xtw.WriteEndElement();