将DataTable的数据保存到XML中
来源:互联网 发布:证券交易网络 编辑:程序博客网 时间:2024/06/09 19:46
/// <summary>
/// 读取XML中的数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string StrPath = AppDomain.CurrentDomain.BaseDirectory + "\\DBConnect.xml";
string Astr = File.ReadAllText(StrPath, Encoding.GetEncoding("gb2312"));
DataTable Atbl = XmlToDataTable(Astr);
}
/// <summary>
/// 将Data Table的数据写入到XML中
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
DataTable Atb = new DataTable("Stu");
Atb.Columns.Add("Name");
Atb.Columns.Add("Sex");
DataRow Adr = Atb.NewRow();
Adr["Name"] = "高晓宇";
Adr["Sex"] = "22";
Atb.Rows.Add(Adr);
Adr = Atb.NewRow();
Adr["Name"] = "高小牛";
Adr["Sex"] = "1";
Atb.Rows.Add(Adr);
string Astr = DataTable2Xml(Atb);
string StrPath = AppDomain.CurrentDomain.BaseDirectory + "\\DBConnect.xml";
File.WriteAllText(StrPath, Astr, Encoding.GetEncoding("gb2312"));//不存在该XML文件时会自动生成一个文件
}
/// <summary>
/// 将XML生成DataTable
/// </summary>
/// <param name="xmlStr">XML字符串</param>
/// <returns></returns>
public static DataTable XmlToDataTable(string xmlStr)
{
if (!string.IsNullOrEmpty(xmlStr))
{
StringReader StrStream = null;
XmlTextReader Xmlrdr = null;
try
{
DataSet ds = new DataSet();
//读取字符串中的信息
StrStream = new StringReader(xmlStr);
//获取StrStream中的数据
Xmlrdr = new XmlTextReader(StrStream);
//ds获取Xmlrdr中的数据
ds.ReadXml(Xmlrdr);
return ds.Tables[0];
}
catch (Exception e)
{
return null;
}
finally
{
//释放资源
if (Xmlrdr != null)
{
Xmlrdr.Close();
StrStream.Close();
StrStream.Dispose();
}
}
}
return null;
}
/// <summary>
/// 将datatable转为xml
/// </summary>
/// <param name="vTable">要生成XML的DataTable</param>
/// <returns></returns>
public static string DataTable2Xml(DataTable vTable)
{
if (null == vTable) return string.Empty;
StringWriter writer = new StringWriter();
vTable.WriteXml(writer);
string xmlstr = writer.ToString();
writer.Close();
return xmlstr;
}
/// 读取XML中的数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string StrPath = AppDomain.CurrentDomain.BaseDirectory + "\\DBConnect.xml";
string Astr = File.ReadAllText(StrPath, Encoding.GetEncoding("gb2312"));
DataTable Atbl = XmlToDataTable(Astr);
}
/// <summary>
/// 将Data Table的数据写入到XML中
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
DataTable Atb = new DataTable("Stu");
Atb.Columns.Add("Name");
Atb.Columns.Add("Sex");
DataRow Adr = Atb.NewRow();
Adr["Name"] = "高晓宇";
Adr["Sex"] = "22";
Atb.Rows.Add(Adr);
Adr = Atb.NewRow();
Adr["Name"] = "高小牛";
Adr["Sex"] = "1";
Atb.Rows.Add(Adr);
string Astr = DataTable2Xml(Atb);
string StrPath = AppDomain.CurrentDomain.BaseDirectory + "\\DBConnect.xml";
File.WriteAllText(StrPath, Astr, Encoding.GetEncoding("gb2312"));//不存在该XML文件时会自动生成一个文件
}
/// <summary>
/// 将XML生成DataTable
/// </summary>
/// <param name="xmlStr">XML字符串</param>
/// <returns></returns>
public static DataTable XmlToDataTable(string xmlStr)
{
if (!string.IsNullOrEmpty(xmlStr))
{
StringReader StrStream = null;
XmlTextReader Xmlrdr = null;
try
{
DataSet ds = new DataSet();
//读取字符串中的信息
StrStream = new StringReader(xmlStr);
//获取StrStream中的数据
Xmlrdr = new XmlTextReader(StrStream);
//ds获取Xmlrdr中的数据
ds.ReadXml(Xmlrdr);
return ds.Tables[0];
}
catch (Exception e)
{
return null;
}
finally
{
//释放资源
if (Xmlrdr != null)
{
Xmlrdr.Close();
StrStream.Close();
StrStream.Dispose();
}
}
}
return null;
}
/// <summary>
/// 将datatable转为xml
/// </summary>
/// <param name="vTable">要生成XML的DataTable</param>
/// <returns></returns>
public static string DataTable2Xml(DataTable vTable)
{
if (null == vTable) return string.Empty;
StringWriter writer = new StringWriter();
vTable.WriteXml(writer);
string xmlstr = writer.ToString();
writer.Close();
return xmlstr;
}
阅读全文
0 0
- 将DataTable的数据保存到XML中
- DataSet 转 DataTable 将数据保存到excel中winform
- 将数据库中表的数据保存到XML文件中
- 将DataTable中筛选中的结果保存到另外的DataTable
- 将多个DataTable添加到指定的DataSet中,转换DataSet为XML,将DataTable转换XML
- NPOI,将Excel表的数据存放到DataTable中
- 将DataTable数据导出到Excel中
- 克隆datatable,并将数据也克隆到datatable中
- 将dataTable 保存到本地txt文件中
- 将dateset或者datatable直接保存到数据库的表中
- 将DataTable中的数据以Xml格式写到指定的文件内,并读取
- 将数据以表格的形式保存到pdf中
- 将GridView数据转入datatable,并将数据保存到固定路径
- XML的数据提取和保存到数据库中
- Android--将数据保存到SDCard中
- 将List数据保存到Excel中
- 将MATLAB数据保存到Excel中
- Android--将数据保存到SDCard中
- Phoenix和Hbase整合
- Resolution In Linux Desktop
- BottomNavigationView去掉动画效果
- rman恢复system表空间
- Nginx搭建hls流媒体服务器
- 将DataTable的数据保存到XML中
- NUMA体系结构简述
- 设计新人到设计新人=菜鸟到菜鸟?NO!
- 【Android】第二章 四大应用组件之Activity
- HTML学习笔记(一)
- ESP8266学习笔记8:ESP8266接入机智云
- 职业经验 历历在目的 2年 测试生活
- 实战 | 封装解决WebView的那些坑
- 【T.I.J】Map通过关联数组的简单实现