本人代码如下:
Public Sub DataUpdateAndShow(ByVal tmpDataTable As DataTable)
'tmpDataTable 包含将要用于更新的700行数据,
'注:'tmpDataTable(其包含两个字段strId和strData ) 用于保存需要更新的行数据,如果只有100行数据,能更新,但连续更新至第7此时就报错,如果一次存在700行以上的数据更行操作,只要第一次更新就报错。
Dim miConnection As New MapInfo.Data.MIConnection
miConnection.Open()
Dim miCommand As New MapInfo.Data.MICommand
miCommand.Connection = miConnection
Dim Cat As MapInfo.Data.Catalog = MapInfo.Engine.Session.Current.Catalog
For i As Integer = 0 To tmpDataTable.Rows.Count - 1
Dim strId As String = tmpDataTable.Rows(i).Item(0).ToString
Dim strData As String = tmpDataTable.Rows(i).Item(1).ToString
miCommand.CommandText = "update myTable set col_Data='" & strData & "' where col_Id= '" & strId & "'"
miCommand.ExecuteNonQuery()
Next