如何将 DataTable 序列化为 json 或 xml

how to serialize a DataTable to json or xml(如何将 DataTable 序列化为 json 或 xml)

问题描述

我正在尝试将 DataTable 序列化为 Json 或 XML.有可能吗?如何?任何教程和想法，请.

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

例如有一个sql表:

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#代码:

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?

推荐答案

XML 很简单:

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

这篇关于如何将 DataTable 序列化为 json 或 xml的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！