将DataTable对象转换成XML字符串

1

///

<summary>

2

 

///

将DataTable对象转换成XML字符串

3

///

</summary>

4

///

<param name="xmlDT">

DataTable对象

</param>

5

///

<returns>

XML字符串

</returns>

6

private

string

ConvertDataTableToXML(DataTable xmlDT)

7

{

8

MemoryStream stream

=

null

;

9

XmlTextWriter writer

=

null

;

10

try

11

{

12

stream

=

new

MemoryStream();

13

writer

=

new

XmlTextWriter(stream, Encoding.Default);

//

根据stream实例化writer

14

xmlDT.TableName

=

"

dt

"

;

15

xmlDT.WriteXml(writer);

//

获取DataTable中的数据

16

int

count

=

(

int

)stream.Length;

17

byte

[] arr

=

new

byte

[count];

18

stream.Seek(

0

, SeekOrigin.Begin);

19

stream.Read(arr,

0

, count);

20

return

Encoding.GetEncoding(

"

gb2312

"

).GetString(arr).Trim();

//

解决中文乱码问题

21

//

UTF8Encoding utf = new UTF8Encoding();

22

//

return utf.GetString(arr).Trim();

23

}

24

catch

(Exception e)

25

{

26

throw

e;

27

}

28

finally

29

{

30

if

(writer

!=

null

)

31

writer.Close();

32

}

33

}

将Xml字符串转换成DataTable对象

1

///

<summary>

2

///

将Xml字符串转换成DataTable对象

3

///

</summary>

4

///

<param name="xmlData">

Xml字符串

</param>

5

///

<returns>

DataTable对象

</returns>

6

private

DataTable ConvertXMLToDataTable(

string

xmlData)

7

{

8

StringReader stream

=

null

;

9

XmlTextReader reader

=

null

;

10

try

11

{

12

DataSet xmlDS

=

new

DataSet();

13

stream

=

new

StringReader(xmlData);

//

读取字符串中的信息

14

reader

=

new

XmlTextReader(stream);

//

获取stream中的数据

15

xmlDS.ReadXml(reader);

//

DataSet获取Xmlrdr中的数据

16

return

xmlDS.Tables[

0

];

17

}

18

catch

(Exception e)

19

{

20

throw

e;

21

}

22

finally

23

{

24

if

(reader

!=

null

)

25

reader.Close();

26

}

27

}