I'm having difficulty with a function and can't find what the problem is.
The code is below. Essentially, it works fine if the target table (tbl
variable in code) is empty, however if it contains rows prior to the method
being called, the error "'column' argument cannot be null" is thrown on the
tbl.merge line. Any help would be greatly appreciated.
''' <summary>Import s data from the table passed in.</summary>
''' <returns>Numb er of successfully imported rows. Returns 0 for
error.</returns>
Public Function AppendDataTable (ByVal SourceDataTable As DataTable) As
Int32
If SourceDataTable Is Nothing Then
Return 0
End If
Try
Dim ds As DataSet = DirectCast(mBin dingSource.Data Source, DataSet)
Dim tbl As DataTable = ds.Tables(mBind ingSource.DataM ember)
tbl.Merge(Sourc eDataTable, True, MissingSchemaAc tion.Ignore) '
error is thrown by this line
' some other stuff happens here specific to my code, but removed
for simplicity
Return SourceDataTable .Rows.Count
Catch ex As Exception
Return 0
End Try
End Function
The code is below. Essentially, it works fine if the target table (tbl
variable in code) is empty, however if it contains rows prior to the method
being called, the error "'column' argument cannot be null" is thrown on the
tbl.merge line. Any help would be greatly appreciated.
''' <summary>Import s data from the table passed in.</summary>
''' <returns>Numb er of successfully imported rows. Returns 0 for
error.</returns>
Public Function AppendDataTable (ByVal SourceDataTable As DataTable) As
Int32
If SourceDataTable Is Nothing Then
Return 0
End If
Try
Dim ds As DataSet = DirectCast(mBin dingSource.Data Source, DataSet)
Dim tbl As DataTable = ds.Tables(mBind ingSource.DataM ember)
tbl.Merge(Sourc eDataTable, True, MissingSchemaAc tion.Ignore) '
error is thrown by this line
' some other stuff happens here specific to my code, but removed
for simplicity
Return SourceDataTable .Rows.Count
Catch ex As Exception
Return 0
End Try
End Function
Comment