How to print the first field in DataTable with VB.NET

2 Answers

0 votes
Module Module1

    Sub Main()

        Dim table As New DataTable

        table.Columns.Add("ID", GetType(Integer))
        table.Columns.Add("Name", GetType(String))
        table.Columns.Add("Salary", GetType(Double))

        table.Rows.Add(123, "Ajax", 23492)
        table.Rows.Add(543, "Arrow", 31871)
        table.Rows.Add(876, "Axel", 16878)
        table.Rows.Add(342, "Everly", 46123)

        For Each row As DataRow In table.Rows
            Console.WriteLine(row.Field(Of Integer)(0))
        Next

    End Sub

End Module

' run:
' 
' 123
' 543
' 876
' 342

 



answered Sep 28, 2018 by avibootz
0 votes
Module Module1

    Sub Main()

        Dim table As New DataTable

        table.Columns.Add("ID", GetType(Integer))
        table.Columns.Add("Name", GetType(String))
        table.Columns.Add("Salary", GetType(Double))

        table.Rows.Add(123, "Ajax", 23492)
        table.Rows.Add(543, "Arrow", 31871)
        table.Rows.Add(876, "Axel", 16878)
        table.Rows.Add(342, "Everly", 46123)

        Console.WriteLine(table.Rows(0).Field(Of Integer)(0))
        Console.WriteLine(table.Rows(1).Field(Of Integer)(0))
        Console.WriteLine(table.Rows(2).Field(Of Integer)(0))
        Console.WriteLine(table.Rows(3).Field(Of Integer)(0))

    End Sub

End Module

' run:
' 
' 123
' 543
' 876
' 342

 



answered Sep 28, 2018 by avibootz

Related questions

1 answer 240 views
1 answer 280 views
1 answer 301 views
1 answer 356 views
1 answer 295 views
1 answer 255 views
1 answer 240 views
...