如何序列化一个DataTable到JSON或XML [英] how to serialize a DataTable to json or xml

问题描述

我试图序列化数据表到JSON或XML。它是可能的，如何？任何教程和想法，请。

例如一个有一个SQL表：

  CREATE TABLE [DBO]。[dictTable]（
    [的keyValue] [INT] IDENTITY（1,1）NOT NULL，
    [valueValue] [INT] NULL，
 约束[Psd2Id] PRIMARY KEY CLUSTERED
（
    [的keyValue] ASC
）WITH（PAD_INDEX = OFF，IGNORE_DUP_KEY = OFF）ON [PRIMARY]
）ON [PRIMARY]
 

C＃code：

 字符串的connectionString =
          服务器=本地主机;数据库= DBD; UID = **; PWD = **;

            的SqlConnection的MySqlConnection =新的SqlConnection（的connectionString）;
            字符串selectString =SELECT的keyValue，valueValue FROM预知;

            的SqlCommand的MySqlCommand = mySqlConnection.CreateCommand（）;

            mySqlCommand.CommandText = selectString;

            SqlDataAdapter的MySqlDataAdapter的=新的SqlDataAdapter（）;

            mySqlDataAdapter.SelectCommand =的MySqlCommand;

            数据集myDataSet =新的DataSet（）;

            mySqlConnection.Open（）;

            字符串dataTableName =字典;
            mySqlDataAdapter.Fill（myDataSet，dataTableName）;

            数据表myDataTable = myDataSet.Tables [dataTableName]
            //现在如何序列化呢？
 

解决方案

到XML很简单：

 数据表myTable的=新的DataTable（）;
myTable.WriteXml（@C：\ MYFILE）;
 

i'm trying to serialize DataTable to Json or XML. is it possibly and how? any tutorials and ideas, please.

For example a have a sql table:

CREATE TABLE [dbo].[dictTable](
    [keyValue] [int] IDENTITY(1,1) NOT NULL,
    [valueValue] [int] NULL,
 CONSTRAINT [Psd2Id] PRIMARY KEY CLUSTERED 
(
    [keyValue] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

C# code:

string connectionString =
          "server=localhost;database=dbd;uid=**;pwd=**";

            SqlConnection mySqlConnection = new SqlConnection(connectionString);
            string selectString =  "SELECT keyValue, valueValue FROM dicTable";

            SqlCommand mySqlCommand = mySqlConnection.CreateCommand();

            mySqlCommand.CommandText = selectString;

            SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();

            mySqlDataAdapter.SelectCommand = mySqlCommand;

            DataSet myDataSet = new DataSet();

            mySqlConnection.Open();

            string dataTableName = "dictionary";
            mySqlDataAdapter.Fill(myDataSet, dataTableName);

            DataTable myDataTable = myDataSet.Tables[dataTableName];
            //now how to serialize it?

解决方案

To XML it's simple:

DataTable myTable = new DataTable();
myTable.WriteXml(@"c:\myfile");

这篇关于如何序列化一个DataTable到JSON或XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！