I like to go thru all the records that Im getting from the select statement. But I dont know how to do it.
P.S I know it can be done with a While but Im not sure how to do this.
Dim DBConn As PsqlConnection
Dim command As New PsqlCommand
Dim statement As String
Dim SQLCom As New SqlCommand
Dim table As New DataTable
DBConn = New PsqlConnection("ServerDSN=dsn;UID=user;PWD=pass; Server=servername")
statement = "select NAME from EMPLOYEE"
command = New PsqlCommand(statement, DBConn)