[TestMethod]
public void ExportXML()
{
string xmlPath = "E:\\IoTPlatform\\IoTPlatformSolution\\IoTPlatformUnitTest\\xml\\project.xml";
string xmlPath1 = "E:\\IoTPlatform\\IoTPlatformSolution\\IoTPlatformUnitTest\\xml\\project1.xml";
string xmlPath2 = "E:\\IoTPlatform\\IoTPlatformSolution\\IoTPlatformUnitTest\\xml\\projectmode.xml";
if (!File.Exists(xmlPath))
{
File.Create(xmlPath);
}
else if (!File.Exists(xmlPath1))
{
File.Create(xmlPath1);
}
else if (!File.Exists(xmlPath2))
{
File.Create(xmlPath2);
}
else
{
string sql = @"select * from dbo.MonitorProjects where MonitorProjectName = 'textPN_4935'";
mycon.Open();
SqlDataAdapter myda = new SqlDataAdapter(sql, conStr);
DataSet myds = new DataSet();
myda.Fill(myds);
myds.WriteXmlSchema(xmlPath);
myds.WriteXml(xmlPath1);
myds.WriteXml(xmlPath2, XmlWriteMode.WriteSchema);
}
}
效果: