System.Author
Windows属性是一个多值字符串. Windows搜索将此值作为DataColumn中的字符串数组返回. (列的数据类型是string []或String().)当我在结果数据表上调用WriteXML方法时,我得到以下InvalidOperationException异常.
有没有办法指定数据表的xml-serializer用于特定列或特定数据类型？
基本上,如何使WriteXML与此数据表一起使用？
System.InvalidOperationException:
Type System.String[] does not
implement IXmlSerializable interface
therefore can not proceed with
serialization.
解决方法
您可以轻松地复制DataTable,将违规的Authors列更改为String,并将字符串[]数据与正确的分隔符(如“|”)联接起来要么 ”; ”.
DataTable xmlFriendlyTable = oldTable.Clone();
xmlFriendlyTable.Columns["Author"].DataType = typeof(String);
xmlFriendlyTable.Columns["Author"].ColumnMapping = MappingType.Element;
foreach(var row in oldTable.Rows) {
object[] rowData = row.ItemArray;
object[] cpyRowData = new object[rowData.Length];
for(int i = 0; i<rowData.Length; i++) {
if(rowData[i] != null && rowData[i].GetType() == typeof(String[])) {
cpyRowData[i] = String.Join("; ",(rowData[i] as String[]));
} else {
cpyRowData[i] = rowData[i];
}
xmlFriendlyTable.Rows.Add(cpyRowData);
}
}
xmlFriendlyTable.WriteXml( ... );
