How do i get all columns / rows from my Database [VB.Net/MariaDB]

Question

I am trying to get all results with the MySQL.Data Nuget because I am using MariaDB. But my Method just provides the first entry in my DB and does nothing more.

Public Function getAllFields(ByVal sql As String) As List(Of String)
        Dim output As List(Of String) = New List(Of String)

        Using cn = New MySqlConnection(connString.ToString())

            Using cmd = New MySqlCommand(sql, cn)
                cn.Open()

                Using rd = cmd.ExecuteReader()
                    rd.Read()

                    Dim objs(rd.FieldCount) As Object
                    Dim quant As Integer = rd.GetValues(objs)
                    Dim i As Integer
                    For i = 0 To quant - 1
                        output.Add(objs(i))
                    Next i
                    rd.Close()
                End Using

                cn.Close()
            End Using
        End Using

        Return output

    End Function

can you try this While rd.Read() /*Codes*/ End While

OMANSAK
– OMANSAK

2019-08-06 08:17:33 +00:00
Commented Aug 6, 2019 at 8:17 — OMANSAK
– OMANSAK, Commented Aug 6, 2019 at 8:17

RobertBaron · Accepted Answer · 2019-08-06 08:44:27Z

1

The call to rd.Read returns True when data is read, and False otherwise. So you need to loop until it returns False.

Using rd = cmd.ExecuteReader()
    While rd.Read()
        Dim objs(rd.FieldCount) As Object
        Dim quant As Integer = rd.GetValues(objs)
        Dim i As Integer
        For i = 0 To quant - 1
            output.Add(objs(i))
        Next i
    End While
End Using

answered Aug 6, 2019 at 8:44

RobertBaron

2,8641 gold badge15 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do i get all columns / rows from my Database [VB.Net/MariaDB]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related