本文实例讲述了C#保存与读取DataTable信息到XML格式的方法。分享给大家供大家参考。具体如下：
这里主要实现：
1.将DataTable中的信息保存到XML中
2.将以上述格式在XML中保存的信息读取到DataTable内
一、将DataTable的内容写入到XML文件中
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
/// <summary>
/// 将DataTable的内容写入到XML文件中
/// </summary>
/// <param name="dt">数据源</param>
/// <param name="address">XML文件地址</param>
public static bool WriteToXml(DataTable dt, string address)
{
try
{
//如果文件DataTable.xml存在则直接删除
if (File.Exists(address))
{
File.Delete(address);
}
XmlTextWriter writer =
new XmlTextWriter(address, Encoding.GetEncoding("GBK"));
writer.Formatting = Formatting.Indented;
//XML文档创建开始
writer.WriteStartDocument();
writer.WriteComment("DataTable: " + dt.TableName);
writer.WriteStartElement("DataTable"); //DataTable开始
writer.WriteAttributeString("TableName", dt.TableName);
writer.WriteAttributeString("CountOfRows", dt.Rows.Count.ToString());
writer.WriteAttributeString("CountOfColumns", dt.Columns.Count.ToString());
writer.WriteStartElement("ClomunName", ""); //ColumnName开始
for (int i = 0; i < dt.Columns.Count; i++)
{
writer.WriteAttributeString(
"Column" + i.ToString(), dt.Columns[i].ColumnName);
}
writer.WriteEndElement(); //ColumnName结束
//按行各行
for (int j = 0; j < dt.Rows.Count; j++)
{
writer.WriteStartElement("Row" + j.ToString(), "");
//打印各列
for (int k = 0; k < dt.Columns.Count; k++)
{
writer.WriteAttributeString(
"Column" + k.ToString(), dt.Rows[j][k].ToString());
}
writer.WriteEndElement();
}
writer.WriteEndElement(); //DataTable结束
writer.WriteEndDocument();
writer.Close();
//XML文档创建结束
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return false;
}
return true;
}
|
二、将以上述格式在XML中保存的信息读取到DataTable内
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
/// <summary>
/// 从XML文件中读取一个DataTable
/// </summary>
/// <param name="dt">数据源</param>
/// <param name="address">XML文件地址</param>
/// <returns></returns>
public static DataTable ReadFromXml(string address)
{
DataTable dt = new DataTable();
try
{
if (!File.Exists(address))
{
throw new Exception("文件不存在!");
}
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(address);
XmlNode root = xmlDoc.SelectSingleNode("DataTable");
//读取表名
dt.TableName = ((XmlElement)root).GetAttribute("TableName");
//Console.WriteLine("读取表名： {0}", dt.TableName);
//读取行数
int CountOfRows = 0;
if (!int.TryParse(((XmlElement)root).
GetAttribute("CountOfRows").ToString(), out CountOfRows))
{
throw new Exception("行数转换失败");
}
//读取列数
int CountOfColumns = 0;
if (!int.TryParse(((XmlElement)root).
GetAttribute("CountOfColumns").ToString(), out CountOfColumns))
{
throw new Exception("列数转换失败");
}
//从第一行中读取记录的列名
foreach (XmlAttribute xa in root.ChildNodes[0].Attributes)
{
dt.Columns.Add(xa.Value);
//Console.WriteLine("建立列： {0}", xa.Value);
}
//从后面的行中读取行信息
for (int i = 1; i < root.ChildNodes.Count; i++)
{
string[] array = new string[root.ChildNodes[0].Attributes.Count];
for (int j = 0; j < array.Length; j++)
{
array[j] = root.ChildNodes[i].Attributes[j].Value.ToString();
}
dt.Rows.Add(array);
//Console.WriteLine("行插入成功");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return new DataTable();
}
return dt;
}
|
三、Main函数调用
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
static void Main(string[] args)
{
//1.将DataTable内容写入到XML文件
//建立DataTable取名Table4Test
DataTable dt1 = new DataTable("Table4Test");
//生成四列，列名为Column0-3
dt1.Columns.Add("Column0");
dt1.Columns.Add("Column1");
dt1.Columns.Add("Column2");
dt1.Columns.Add("Column3");
//生成四行
dt1.Rows.Add("A0", "A1", "A2", "A3");
dt1.Rows.Add("B0", "B1", "B2", "B3");
dt1.Rows.Add("C0", "C1", "C2", "C3");
//写入到XML
if (WriteToXml(dt1, "DataTable.xml"))
{
Console.WriteLine("写入成功");
}
//================================
//2.从XML文件中读取内容到DataTable
//读取信息
DataTable dt2 = ReadFromXml("DataTable.xml");
//输出读取的信息
Console.WriteLine("读取到的信息：");
for (int i = 0; i < dt2.Rows.Count; i++)
{
for (int j = 0; j < dt2.Columns.Count; j++)
{
Console.Write(dt2.Rows[i][j].ToString() + "\t");
}
Console.WriteLine();
}
Console.ReadLine();
}
|
四、程序运行结果
程序运行结果
写入后的XML文件
希望本文所述对大家的C#程序设计有所帮助。