110,536
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 生成xml方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CreateXml()
{
//数据库连接字符串
string connString = @"Server = .; User Id = sa;"
+ "Password = 123; Persist Security Info = True;database = GolfClub_TX";
//创建MySqlConnection对象
SqlConnection myConnection = new SqlConnection(connString);
//创建DataSet对象
DataSet myDataSet = new DataSet();
//打开数据库
myConnection.Open();
//查询语句
string sqlString = "select * from ADemo; ";
//新建SqlDataAdapter对象,执行查询语句
SqlDataAdapter myMySqlDataAdapter = new SqlDataAdapter(sqlString, myConnection);
//是用Fill方法将所有的数据放在myDataSet中
myMySqlDataAdapter.Fill(myDataSet);
//设置xml文件路径为当前项目的路径,xml文件名为worker
string xmlPath = "C:\\huafei.xml";
//调用writeXml方法,将数据库查询结果写入xml文件
myDataSet.WriteXml(xmlPath);
myConnection.Close();
}
XmlDodument myxml = new XmlDocument();
myxml.Load("student.xml");
XmlNode node = myxml.DocumentElement;
foreach(XmlNode detailNode in node.ChildeNodes)
{
switch(detailNode.Name)
{
//执行可操作代码
}
}
string file = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"data\test.xml");
DataTable datatable1 = new DataTable("Table1");
datatable1.WriteXml(file, XmlWriteMode.WriteSchema);
DataTable datatable2 = new DataTable("Table2");
datatable2.ReadXml(file);
DataSet ds = new DataSet();
ds.WriteXml("xxx.xml");
DataSet ds = new DataSet();
ds.ReadXml("xxx.xml");