我试图序列化数据表到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");