using System;
using System.Data;
using System.Text;
public class JsonUtil
{
// DataSet → JSON { "TableName": [ {col:val}, ... ], ... }
public string ToJson(DataSet ds)
{
if (ds == null || ds.Tables.Count == 0) return "{}";
var sb = new StringBuilder("{");
foreach (DataTable dt in ds.Tables)
{
sb.Append($"\"{dt.TableName}\":");
sb.Append(ToJson(dt));
sb.Append(",");
}
if (sb[sb.Length - 1] == ',') sb.Length--; // 移除尾逗號
sb.Append("}");
return sb.ToString();
}
// DataTable → JSON [ {col:val}, ... ]
public string ToJson(DataTable dt)
{
if (dt == null || dt.Rows.Count == 0) return "[]";
var sb = new StringBuilder("[");
foreach (DataRow row in dt.Rows)
{
sb.Append("{");
for (int c = 0; c < dt.Columns.Count; c++)
{
string colName = dt.Columns[c].ColumnName;
object val = row[c];
string jsonVal = FormatJsonValue(val, dt.Columns[c].DataType);
sb.Append($"\"{JsonEscape(colName)}\":{jsonVal},");
}
if (sb[sb.Length - 1] == ',') sb.Length--;
sb.Append("},");
}
if (sb[sb.Length - 1] == ',') sb.Length--;
sb.Append("]");
return sb.ToString();
}
private string FormatJsonValue(object value, Type type)
{
if (value == null || value == DBNull.Value) return "null";
// 字串、日期、Guid、Enum → 加雙引號並跳脫
if (type == typeof(string) || type == typeof(DateTime) || type == typeof(Guid) || type.IsEnum)
return $"\"{JsonEscape(value.ToString())}\"";
// 布林值
if (type == typeof(bool))
return (bool)value ? "true" : "false";
// 數值型別 (int, long, float, double, decimal 等)
return value.ToString(); // 依賴 CurrentCulture,建議用 InvariantCulture
}
private string JsonEscape(string s)
{
return s.Replace("\\", "\\\\")
.Replace("\"", "\\\"")
.Replace("\n", "\\n")
.Replace("\r", "\\r")
.Replace("\t", "\\t")
.Replace("\b", "\\b")
.Replace("\f", "\\f");
}
}
var util = new JsonUtil();
Response.ContentType = "application/json; charset=utf-8";
Response.Write(util.ToJson(myDataSet));
// NuGet: Install-Package Newtonsoft.Json
using Newtonsoft.Json;
string json = JsonConvert.SerializeObject(dataSet, Formatting.Indented,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Include,
DateFormatString = "yyyy-MM-ddTHH:mm:ss",
ContractResolver = new DefaultContractResolver { NamingStrategy = new CamelCaseNamingStrategy() }
});
Response.Write(json);
using System.Text.Json;
var options = new JsonSerializerOptions
{
WriteIndented = true,
PropertyNamingPolicy = JsonNamingPolicy.CamelCase,
DefaultIgnoreCondition = JsonIgnoreCondition.WhenWritingNull
};
string json = JsonSerializer.Serialize(dataSet, options); // DataSet 需 .NET 6+ 支援,或先轉 List
Response.Write(json);
| 特性 | 手工 StringBuilder | Newtonsoft.Json | System.Text.Json |
|---|---|---|---|
| 效能 | 低 (大量字串操作、無快取) | 高 (表達式樹快取、流式寫入) | 極高 (Span-based、零複製、UTF-8 直接輸出) |
| 日期格式 | 手動控制 | 豐富設定 | ISO 8601 預設,可自訂 |
| 循環參考 | 需自行處理 | ReferenceLoopHandling | ReferenceHandler.Preserve |
| DataTable/DataSet 直接支援 | 需自行實作 | 完美支援 | .NET 6+ 完整支援 |
| 依賴 | 無 | NuGet 套件 | 內建 (Core/5+) |
手工序列化適合**零相依、極簡、資料量小、格式固定**的舊專案維護。所有新專案、高效能需求、複雜物件圖、標準化 API 開發,**請直接使用 Newtonsoft.Json 或 System.Text.Json**,獲得更佳效能、正確性、擴充性與維護性。