DataTable导入、导出xml文件代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】 DataTable导入、导出xml文件

作者:英 / 发布于2015/3/24/ 600


	using System.IO;
	using System.Xml;

	方法一： DataTable导出xml文件

	 private void button1_Click(object sender, EventArgs e)
	 {
	 SaveFileDialog saveFileDialog = new SaveFileDialog();
	 saveFileDialog.Filter = "XML文件|*.xml";
	 saveFileDialog.FilterIndex = 1;
	 saveFileDialog.RestoreDirectory = true;
	 if (saveFileDialog.ShowDialog() == DialogResult.OK)
	 {
	 string fName = saveFileDialog.FileName;
	
	 DataTable dt = new DataTable("a");
	 dt.Columns.Add("Name", typeof(string));
	 dt.Columns.Add("Age", typeof(Int32));
	 DataRow dr;
	 for (int i = 0; i < 5; i++)
	 {
	 dr = dt.NewRow();
	 dr[0] = i.ToString();
	 dr[1] = i;
	 dt.Rows.Add(dr);
	 }
	 DataTableToXML(dt,fName);
	 }
	
	 }
	 public bool DataTableToXML(DataTable dtTable, string strXMLPath)
	 {
	 MemoryStream stream = null;
	 XmlTextWriter writer = null;
	 StreamWriter sw = null;
	 try
	 {
	 stream = new MemoryStream();
	 writer = new XmlTextWriter(stream, Encoding.UTF8);
	 dtTable.WriteXml(writer, XmlWriteMode.WriteSchema);
	 int nCount = (int)stream.Length;
	 byte[] arr = new byte[nCount];
	 stream.Seek(0, SeekOrigin.Begin);
	 stream.Read(arr, 0, nCount);
	 UTF8Encoding utf = new UTF8Encoding();
	 string strContent = utf.GetString(arr).Trim();
	 sw = new StreamWriter(strXMLPath);
	 sw.Write(strContent);

	 return true;
	 }
	 catch (System.Exception vErr)
	 {
	 MessageBox.Show(vErr.Message);
	 return false;
	 }
	 finally
	 {
	 if (writer != null)
	 {
	 writer.Close();
	 }
	 if (sw != null)
	 {
	 sw.Close();
	 }
	 }
	 }

	方法二：DataTable读取xml文件

	 private void button2_Click(object sender, EventArgs e)
	 {
	 OpenFileDialog open = new OpenFileDialog();
	 open.Filter = "Xml文件|*.xml";
	 if (open.ShowDialog() == DialogResult.OK)
	 {
	 string path = open.FileName;
	 DataTable dt = XMLToDataTable(path);
	 }
	 }
	 public DataTable XMLToDataTable(string strXMLPath)
	 {
	 StringReader stream = null;
	 XmlTextReader reader = null;
	 StreamReader sr = null;
	 try
	 {
	 if (strXMLPath.Length <= 0)
	 {
	 return new DataTable();
	 }
	 sr = new StreamReader(strXMLPath);
	 string strXmlContent = sr.ReadToEnd();
	 stream = new StringReader(strXmlContent);
	 reader = new XmlTextReader(stream);
	 DataSet ds = new DataSet();
	 ds.ReadXml(reader);
	 return ds.Tables[0];
	 }
	 catch (System.Exception vErr)
	 {
	 MessageBox.Show(vErr.Message);
	 }
	 finally
	 {
	 if (sr != null)
	 sr.Close();
	 if (reader != null)
	 reader.Close();
	 }
	 return new DataTable();
	 }

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　DataTable导入　

同语言下

可能有用的

英贡献的其它代码(4)