Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odatatable.rows.add(oDatatow)
Message
 
To
All
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
Odatatable.rows.add(oDatatow)
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows NT
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01558336
Message ID:
01558336
Views:
63
Consider the following code
    Public Sub testDatarows()
        Dim oDt As New DataTable
        oDt.Columns.Add("Field1", GetType(String))
        oDt.Columns.Add("Field2", GetType(String))
        oDt.Columns.Add("Field3", GetType(String))
        Dim odr As DataRow = oDt.NewRow
        odr("Field1") = "value 1"
        odr("Field2") = "value 2"
        odr("Field3") = "value 3"
        oDt.Rows.Add(odr)
        odr("Field3") = "value 4"
        oDt.Rows.Add(odr)
        For Each odr In oDt.Rows
            Debug.Print(odr("Field1") & "- " & odr("field2") & "-" & odr("Field3"))
        Next
    End Sub
It breaks at the second
oDt.Rows.Add(odr)
throwing an exception : {"This row already belongs to this table."}

Is there a way around this besides issuing a new
 odr = oDt.NewRow
and copy and pasting the assignments of the two first fields?

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Next
Reply
Map
View

Click here to load this message in the networking platform