c# dataset保存多属性的XML

来源：互联网发布：windows 会员如何加入编辑：程序博客网时间：2024/04/28 23:02

　　　 DataSet ds = new DataSet("encryption");                        DataColumn Cw = new DataColumn("InfoID", typeof(string));            DataColumn Cwnum = new DataColumn("Password", typeof(string));            DataTable dt = ds.Tables.Add("info");            dt.Columns.Add(Cw);            dt.Columns.Add(Cwnum);                        DataRow dr = dt.NewRow();            dr["InfoID"] = "05";            dr["Password"] = "22";                        dt.Rows.Add(dr);            DataRow dr1 = dt.NewRow();            dr1["InfoID"] = "02";            dr1["Password"] = "12";                        dt.Rows.Add(dr1);            dt.WriteXml("userinfo.xml");

生成的格式为:

<?xml version="1.0" standalone="yes"?><encryption>  <info>    <InfoID>05</InfoID>    <Password>22</Password>  </info>  <info>    <InfoID>02</InfoID>    <Password>12</Password>  </info></encryption>

 DataSet ds = new DataSet("encryption");                        DataColumn Cw = new DataColumn("InfoID", typeof(string));            DataColumn Cwnum = new DataColumn("Password", typeof(string));            DataTable dt = ds.Tables.Add("info");            dt.Columns.Add(Cw);            dt.Columns.Add(Cwnum);                        DataRow dr = dt.NewRow();            dr["InfoID"] = "05";            dr["Password"] = "22";                        dt.Rows.Add(dr);            DataRow dr1 = dt.NewRow();            dr1["InfoID"] = "02";            dr1["Password"] = "12";                        dt.Rows.Add(dr1);            //dt.WriteXml("userinfo.xml");            foreach (DataColumn dc in dt.Columns)            {                dc.ColumnMapping = MappingType.Attribute;            }            dt.WriteXml("userinfo.xml");

生成多属性的格式:

<?xml version="1.0" standalone="yes"?>  <encryption>    <info InfoID="05" Password="22" />    <info InfoID="02" Password="12" />  </encryption>

如果是将数据库查询的数据形成多属性的XML时:

SqlConnection cnPubs = new SqlConnection("Data Source=<servername>;user id=<username>;                       password=<Password>;Initial Catalog=Pubs;");SqlDataAdapter daAuthors = new SqlDataAdapter("Select * from Authors",cnPubs);DataSet ds = new DataSet();cnPubs.Open();daAuthors.Fill(ds,"Authors");DataTable dt ;dt = ds.Tables["Authors"];foreach (DataColumn dc in dt.Columns){dc.ColumnMapping = MappingType.Attribute;}ds.WriteXml("Authors.xml");

0 0