java datatable json_C# DataTable转JSON

public static string DtToJSON(DataTable dt, Int64 totlalCount, Dictionary dict, string DateTimeFormat)

{

string test = "";

if (dt == null)

return "";

if (totlalCount == 0)

totlalCount = dt.Rows.Count;

StringBuilder sb = new StringBuilder();

StringWriter sw = new StringWriter(sb);

using (JsonWriter writer = new JsonTextWriter(sw))

{

writer.WriteStartObject();

writer.WritePropertyName("totalCount");

writer.WriteValue(totlalCount.ToString());

if (string.IsNullOrEmpty(dt.TableName))

writer.WritePropertyName("Table");

else

writer.WritePropertyName(dt.TableName.ToString());

IsoDateTimeConverter idt = new IsoDateTimeConverter();

idt.DateTimeFormat = DateTimeFormat;

writer.WriteRawValue(JsonConvert.SerializeObject(dt, idt, new DataTableConverter()));

foreach (KeyValuePair kv in dict)

{

writer.WritePropertyName(kv.Key);

writer.WriteValue(kv.Value);

}

writer.WriteEndObject();

test = sb.ToString();

}

return test;

}