JsonConvert空值的处理
这里的空值指的是引用类型为NULL时,Json.Net如何处理.通过设置jSetting.NullValueHandling的值来确定,该值为枚举类型.
NullValueHandling.Ignore
忽略为NULL的值
NullValueHandling.Include
默认值,包括为NULL的值
实例:
Staff jack = new Staff { Name = "Jack", Age = 31, Gender = "Male", DepartmentName = "Personnel Department", Leader = null };
var jSetting = new JsonSerializerSettings();
jSetting.NullValueHandling = NullValueHandling.Ignore;
string json = JsonConvert.SerializeObject(jack,jSetting);
Console.WriteLine(json);
狐表代码该咋处理呢
Dim dt As DataTable
Dim cmd As New SQLCommand
cmd.CommandText = "S elect * from {表A} where 单号 = 'A001'"
dt = cmd.ExecuteReader()
If dt.DataRows.Count > 0 Then
Dim dtCopy As System.Data.DataTable = dt.BaseTable.Copy
dtCopy.Columns.Remove("System_Sort_Temporary")
dtCopy.Columns.Remove("System_Filter_Temporary")
dtCopy.Columns.Remove("System_Filter_Unique")
Dim s As String = JsonConvert.SerializeObject(dtCopy)
'e.WriteString(s) '生成网页
Output.Show(s.ToString)
End If