根据数据库生成xml二法

根据数据库生成xml二法

根据数据库生成xml二法

SqlConnection conn = new SqlConnection();

conn.ConnectionString = 'Server=127.0.0.1;User ID=sa;Password=fdahgdrethj31313210212121;Database=northwind;Persist Security Info=True';

conn.Open();

SqlDataAdapter da = new SqlDataAdapter('select * from 表', conn);

SqlCommandBuilder thisBulder = new SqlCommandBuilder(da);

DataSet ds = new DataSet();

da.Fill(ds);

ds.WriteXml(@'C:\temp.xml');

==============================================================================private void WriteXmlToFile(DataSet thisDataSet) {

if (thisDataSet == null) { return; }

// Create a file name to write to.

string filename = 'myXmlDoc.xml';

// Create the FileStream to write with.

System.IO.FileStream myFileStream = new System.IO.FileStream

(filename, System.IO.FileMode.Create);

// Create an XmlTextWriter with the fileStream.

System.Xml.XmlTextWriter myXmlWriter =

new System.Xml.XmlTextWriter(myFileStream, System.Text.Encoding.Unicode);

// Write to the file with the WriteXml method.

thisDataSet.WriteXml(myXmlWriter);

myXmlWriter.Close();

}

 

 

 

免责声明：本文为网络用户发布，其观点仅代表作者个人观点，与本站无关，本站仅提供信息存储服务。文中陈述内容未经本站证实，其真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。