VB.NET向WCF服务传递二维数组报错：二维数组不支持

这个问题我之前也碰到过——WCF的默认序列化机制（比如DataContractSerializer）确实不支持直接传递二维数组（像你代码里的String(,)），因为它没法直接映射到标准的XML或JSON序列化结构里。下面给你两种简单可行的解决办法：

方案一：改用锯齿数组（Jagged Array） #

锯齿数组是一维数组的数组（String()()），这是WCF完全支持的类型，实现起来也很直接：

1. 修改服务契约（IService1） #

把方法里的二维数组参数换成锯齿数组：

<ServiceContract>
Public Interface IService1
    <OperationContract>
    Function Retrieve(ByRef rows As Integer, ByRef columns As Short, ByRef resArray As String()(), ByVal identifier As Short) As Short
End Interface

2. 更新服务实现代码 #

在你的Retrieve方法里，把数据库获取到的二维数组转换成锯齿数组：

Function Retrieve(ByRef rows As Integer, ByRef columns As Short, ByRef resArray As String()(), ByVal identifier As Short) As Short Implements IService1.Retrieve
    If identifier = 0 Then
        Dim obj As New clsNews
        ' 假设obj.GetData()返回你原来的二维String数组
        Dim original2DArray As String(,) = obj.GetData()
        
        ' 获取行列数
        rows = original2DArray.GetLength(0)
        columns = original2DArray.GetLength(1)
        
        ' 转换为锯齿数组
        resArray = New String(rows - 1)() {}
        For i As Integer = 0 To rows - 1
            resArray(i) = New String(columns - 1) {}
            For j As Integer = 0 To columns - 1
                resArray(i)(j) = original2DArray(i, j)
            Next
        Next
        
        Return 0
    End If
    
    ' 处理其他identifier逻辑，返回对应值
    Return 1
End Function

3. 客户端处理 #

客户端拿到锯齿数组后，可以直接遍历填充ListView，或者转成二维数组使用：

' 客户端调用示例
Dim client As New Service1Client()
Dim rows As Integer = 0
Dim cols As Short = 0
Dim dataArray As String()() = Nothing
client.Retrieve(rows, cols, dataArray, 0)

' 填充ListView
ListView1.Columns.Clear()
For i As Integer = 0 To cols - 1
    ListView1.Columns.Add($"列 {i+1}")
Next

ListView1.Items.Clear()
For Each row In dataArray
    Dim listItem As New ListViewItem(row(0))
    For j As Integer = 1 To row.Length - 1
        listItem.SubItems.Add(row(j))
    Next
    ListView1.Items.Add(listItem)
Next

方案二：使用自定义数据契约类（更面向对象） #

如果你的数据需要附带更多元信息（比如列名、表名），或者想让数据结构更清晰，可以定义一个符合WCF数据契约的类来封装表格数据：

1. 定义数据契约类 #

<DataContract>
Public Class TableRow
    <DataMember>
    Public Property Cells As String() ' 一行的所有单元格数据
End Class

<DataContract>
Public Class TableData
    <DataMember>
    Public Property Rows As List(Of TableRow) ' 所有行数据
    <DataMember>
    Public Property RowCount As Integer
    <DataMember>
    Public Property ColumnCount As Short
End Class

2. 修改服务契约 #

直接返回自定义的TableData类型，避免传递多个ByRef参数：

<ServiceContract>
Public Interface IService1
    <OperationContract>
    Function Retrieve(ByVal identifier As Short) As TableData
End Interface

3. 更新服务实现 #

Function Retrieve(ByVal identifier As Short) As TableData Implements IService1.Retrieve
    If identifier = 0 Then
        Dim obj As New clsNews
        Dim original2DArray As String(,) = obj.GetData()
        
        Dim result As New TableData()
        result.RowCount = original2DArray.GetLength(0)
        result.ColumnCount = original2DArray.GetLength(1)
        result.Rows = New List(Of TableRow)()
        
        ' 把二维数组转成TableRow集合
        For i As Integer = 0 To result.RowCount - 1
            Dim row As New TableRow()
            row.Cells = New String(result.ColumnCount - 1) {}
            For j As Integer = 0 To result.ColumnCount - 1
                row.Cells(j) = original2DArray(i, j)
            Next
            result.Rows.Add(row)
        Next
        
        Return result
    End If
    
    ' 其他情况返回空数据或错误标记
    Return New TableData()
End Function

4. 客户端填充ListView #

Dim client As New Service1Client()
Dim tableData As TableData = client.Retrieve(0)

ListView1.Columns.Clear()
For i As Integer = 0 To tableData.ColumnCount - 1
    ListView1.Columns.Add($"列 {i+1}")
Next

ListView1.Items.Clear()
For Each row In tableData.Rows
    Dim listItem As New ListViewItem(row.Cells(0))
    For j As Integer = 1 To row.Cells.Length - 1
        listItem.SubItems.Add(row(j))
    Next
    ListView1.Items.Add(listItem)
Next

注意事项 #

• 不管用哪种方案，修改服务契约后都要更新客户端的服务引用，确保两端契约一致。
• 锯齿数组方案更轻量，适合简单的表格数据传递；自定义数据契约更灵活，适合复杂场景。
• 不推荐自定义序列化器来支持二维数组，会增加代码复杂度，上述两种方案已经能完美解决问题。

内容的提问来源于stack exchange，提问作者Baraa Hrab