2
// Copyright (c) 2007 James Newton-King
4
// Permission is hereby granted, free of charge, to any person
5
// obtaining a copy of this software and associated documentation
6
// files (the "Software"), to deal in the Software without
7
// restriction, including without limitation the rights to use,
8
// copy, modify, merge, publish, distribute, sublicense, and/or sell
9
// copies of the Software, and to permit persons to whom the
10
// Software is furnished to do so, subject to the following
13
// The above copyright notice and this permission notice shall be
14
// included in all copies or substantial portions of the Software.
16
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
17
// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
18
// OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
19
// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
20
// HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
21
// WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
22
// FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
23
// OTHER DEALINGS IN THE SOFTWARE.
26
#if !(SILVERLIGHT || NETFX_CORE || PORTABLE)
29
using Newtonsoft.Json.Serialization;
31
namespace Newtonsoft.Json.Converters
34
/// Converts a <see cref="DataTable"/> to and from JSON.
36
public class DataTableConverter : JsonConverter
39
/// Writes the JSON representation of the object.
41
/// <param name="writer">The <see cref="JsonWriter"/> to write to.</param>
42
/// <param name="value">The value.</param>
43
/// <param name="serializer">The calling serializer.</param>
44
public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
46
DataTable table = (DataTable)value;
47
DefaultContractResolver resolver = serializer.ContractResolver as DefaultContractResolver;
49
writer.WriteStartArray();
51
foreach (DataRow row in table.Rows)
53
writer.WriteStartObject();
54
foreach (DataColumn column in row.Table.Columns)
56
if (serializer.NullValueHandling == NullValueHandling.Ignore && (row[column] == null || row[column] == DBNull.Value))
59
writer.WritePropertyName((resolver != null) ? resolver.GetResolvedPropertyName(column.ColumnName) : column.ColumnName);
60
serializer.Serialize(writer, row[column]);
62
writer.WriteEndObject();
65
writer.WriteEndArray();
69
/// Reads the JSON representation of the object.
71
/// <param name="reader">The <see cref="JsonReader"/> to read from.</param>
72
/// <param name="objectType">Type of the object.</param>
73
/// <param name="existingValue">The existing value of object being read.</param>
74
/// <param name="serializer">The calling serializer.</param>
75
/// <returns>The object value.</returns>
76
public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)
80
if (reader.TokenType == JsonToken.PropertyName)
82
dt = new DataTable((string)reader.Value);
92
while (reader.TokenType == JsonToken.StartObject)
94
DataRow dr = dt.NewRow();
97
while (reader.TokenType == JsonToken.PropertyName)
99
string columnName = (string)reader.Value;
103
if (!dt.Columns.Contains(columnName))
105
Type columnType = GetColumnDataType(reader.TokenType);
106
dt.Columns.Add(new DataColumn(columnName, columnType));
109
dr[columnName] = reader.Value ?? DBNull.Value;
122
private static Type GetColumnDataType(JsonToken tokenType)
126
case JsonToken.Integer:
127
return typeof (long);
128
case JsonToken.Float:
129
return typeof (double);
130
case JsonToken.String:
132
case JsonToken.Undefined:
133
return typeof (string);
134
case JsonToken.Boolean:
135
return typeof (bool);
137
return typeof (DateTime);
139
throw new ArgumentOutOfRangeException();
144
/// Determines whether this instance can convert the specified value type.
146
/// <param name="valueType">Type of the value.</param>
148
/// <c>true</c> if this instance can convert the specified value type; otherwise, <c>false</c>.
150
public override bool CanConvert(Type valueType)
152
return (valueType == typeof(DataTable));
b'\\ No newline at end of file'