In what were replaced metods from VB6 in VB.NET

[miho1]

Hi,

In VB6 ADO was present metods MoveFirst, MoveNext and Move. Last.
In what were replaced in VB.NET?

Thanks

Miho

 

[rasx]

The DataTable contains a Rows Property and this is just a Collection of objects similar to old-school VB6 collections:

Private Sub PrintRows(myDataSet As DataSet)
    ' For each table in the DataSet, print the values of each row.
    Dim thisTable As DataTable
    For Each thisTable In  myDataSet.Tables
        ' For each row, print the values of each column.
        Dim myRow As DataRow
        For Each myRow In  thisTable.Rows
            Dim myCol As DataColumn
            For Each myCol In  thisTable.Columns
                Console.WriteLine(myRow(myCol))
            Next myCol
        Next myRow
    Next thisTable
End Sub

Private Sub AddARow(ds As DataSet)
    Dim t As DataTable
    t = ds.Tables("Suppliers")
    ' Use the NewRow method to create a DataRow with the table's schema.
    Dim newRow As DataRow = t.NewRow()
    ' Set values in the columns:
    newRow("CompanyID") = "NewCompanyID"
    newRow("CompanyName") = "NewCompanyName"
    ' Add the row to the rows collection.
    t.Rows.Add(newRow)
End Sub

Bryan Wilhite
Songhay System

http://www.songhaysystem.com

 

[miho1]

Yes it so. But I ask as I can go on the following row in DataSet or on the first.

Miho