/// <summary>
/// 把dataset数据存到xml文件中
/// </summary>
/// <param name="set">dataset数据表</param>
/// <param name="path">文件要保存到那(虚拟路径)</param>
/// <param name="sqlziduan">数据库中取出的表中的字段</param>
/// <param name="sqlziduan1">数据库中取出的表中的字段</param>
/// <param name="FileName">数据保存成功后,需要保存的路径(物理路径或者根路径)</param>
/// <returns>文件虚拟路径</returns>
public string XmlFile(DataSet set,string path,string sqlziduan,string sqlziduan1,string FileName,string caption,string xName,string yName)
{
XmlClass_zhao xmlclass = new XmlClass_zhao();
//string path = "temp/a.xml";
if (这里面是把dataset数据转换成xml文件)
{
string xmlstring = "<?xml version='1.0' encoding='utf-8' ?><graph caption='"+caption.ToString()+"' xAxisName='"+xName.ToString()+"' yAxisName='"+yName.ToString()+"' showNames='1' decimalPrecision='0' formatNumberScale='0' ></graph>";
XmlDocument xml = new XmlDocument();
xml.LoadXml(xmlstring);
XmlDocumentFragment fra = xml.CreateDocumentFragment();
//DataView da = set.Tables[0].DefaultView;
for (int i = 0; i < 8; i++)
{
//string stm = set.Tables[0].Rows[i][sqlziduan].ToString();
string xmlst = "<set name='" + set.Tables[0].Rows[i] [sqlziduan].ToString() + "' value='" + set.Tables[0].Rows[i] [sqlziduan1].ToString() + "' color='AFD8F8'/>";
fra.InnerXml = xmlst;
xml.DocumentElement.AppendChild(fra);
}
xml.Save(FileName);
#region 另一种方法
//try
//{
// string xmlstring = "<graph caption='每月销售额柱形图' xAxisName='月 份' yAxisName='Units' showNames='1' decimalPrecision='0' formatNumberScale='0' ></graph>";
// XmlNode currNode;
// XmlDocument doc = new XmlDocument();
// doc.LoadXml(xmlstring);
// XmlDocumentFragment docFrag = doc.CreateDocumentFragment();
// for (int i = 0; i <da.Count; i++)
// {
// string xmlst = "<set name='" + set1.Tables[0].Rows[0] [i].ToString() + "' value='"+set1.Tables[0].Rows[1][i].ToString ()+"' color='AFD8F8'/>";
// docFrag.InnerXml = st;
// currNode = doc.DocumentElement.FirstChild;
// currNode.InsertAfter(docFrag, currNode.LastChild);
// }
// doc.Save("a.xml");
//}
//catch (Exception e)
//{
// Console.WriteLine("Exception: {0}", e.ToString());
//}
#endregion
}
return path;
}
/// 把dataset数据存到xml文件中
/// </summary>
/// <param name="set">dataset数据表</param>
/// <param name="path">文件要保存到那(虚拟路径)</param>
/// <param name="sqlziduan">数据库中取出的表中的字段</param>
/// <param name="sqlziduan1">数据库中取出的表中的字段</param>
/// <param name="FileName">数据保存成功后,需要保存的路径(物理路径或者根路径)</param>
/// <returns>文件虚拟路径</returns>
public string XmlFile(DataSet set,string path,string sqlziduan,string sqlziduan1,string FileName,string caption,string xName,string yName)
{
XmlClass_zhao xmlclass = new XmlClass_zhao();
//string path = "temp/a.xml";
if (这里面是把dataset数据转换成xml文件)
{
string xmlstring = "<?xml version='1.0' encoding='utf-8' ?><graph caption='"+caption.ToString()+"' xAxisName='"+xName.ToString()+"' yAxisName='"+yName.ToString()+"' showNames='1' decimalPrecision='0' formatNumberScale='0' ></graph>";
XmlDocument xml = new XmlDocument();
xml.LoadXml(xmlstring);
XmlDocumentFragment fra = xml.CreateDocumentFragment();
//DataView da = set.Tables[0].DefaultView;
for (int i = 0; i < 8; i++)
{
//string stm = set.Tables[0].Rows[i][sqlziduan].ToString();
string xmlst = "<set name='" + set.Tables[0].Rows[i] [sqlziduan].ToString() + "' value='" + set.Tables[0].Rows[i] [sqlziduan1].ToString() + "' color='AFD8F8'/>";
fra.InnerXml = xmlst;
xml.DocumentElement.AppendChild(fra);
}
xml.Save(FileName);
#region 另一种方法
//try
//{
// string xmlstring = "<graph caption='每月销售额柱形图' xAxisName='月 份' yAxisName='Units' showNames='1' decimalPrecision='0' formatNumberScale='0' ></graph>";
// XmlNode currNode;
// XmlDocument doc = new XmlDocument();
// doc.LoadXml(xmlstring);
// XmlDocumentFragment docFrag = doc.CreateDocumentFragment();
// for (int i = 0; i <da.Count; i++)
// {
// string xmlst = "<set name='" + set1.Tables[0].Rows[0] [i].ToString() + "' value='"+set1.Tables[0].Rows[1][i].ToString ()+"' color='AFD8F8'/>";
// docFrag.InnerXml = st;
// currNode = doc.DocumentElement.FirstChild;
// currNode.InsertAfter(docFrag, currNode.LastChild);
// }
// doc.Save("a.xml");
//}
//catch (Exception e)
//{
// Console.WriteLine("Exception: {0}", e.ToString());
//}
#endregion
}
return path;
}