Database query result to display in Label VB.net
<p>I have a label in which I want to display my database query result. But the label displaying only first row not all the records. Can anyone here could help me with this? Tried searching but I found other answers confusing. Please help me. </p>

<p>Here is what I have so far.</p>

<p><strong>FrontEnd</strong></p>

<pre><code>&lt;asp:Label ID="Resulttext" runat="server" Text=""&gt;&lt;/asp:Label&gt;
</code></pre>

<p><strong>Backend</strong></p>

<pre><code>Protected Sub getUser()
        Dim dt As New DataTable()
        Dim conn As SqlConnection = New SqlConnection("myconnectionhere")
        conn.Open()
        Dim cmd As SqlCommand = New SqlCommand("mysqlhere", conn)
        Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
        da.SelectCommand = cmd
        da.Fill(dt)

        If dt.Rows.Count &gt; 0 Then
            Resulttext.Text = dt.Rows(0)("Fullname").ToString
        End If
        conn.Close()
    End Sub
</code></pre>

<p>What I'm doing wrong? Thank you.</p>