value not fetch from sql server 2008 r2 on asp.net page
<p>Page runs properly but no record display on web page.</p>

<p><code>web.cofig</code> file:</p>

<pre><code>&lt;connectionStrings&gt;
     &lt;add name="myConnectionString" 
          connectionString="Data Source=AMIT-PC\R2;Initial Catalog=amit;Integrated Security=True" /&gt;
&lt;/connectionStrings&gt;
</code></pre>

<p><strong>.vb page</strong></p>

<pre><code>Imports System.Data.SqlClient

Public Class Desired_Username
    Inherits System.Web.UI.Page

    Dim connString As String connString=ConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString

    Dim cmd As New SqlCommand
    Dim sqlcnn As New SqlConnection(connString)

    Dim oleda As New SqlDataAdapter
    Dim ds As New DataSet()
    Dim dr As SqlDataReader
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim sel As String = "select * from emp"
        Response.Write(sel)
        sqlcnn.Open()
        'cmd.Connection = sqlcnn
        'cmd.CommandText = sel
        cmd = New SqlCommand(sel, sqlcnn)
        dr = cmd.ExecuteReader()
        While dr.Read()
            Label1.Text = "xcdsfdffsfd"

        End While
        sqlcnn.Close()

    End Sub
End Class
</code></pre>
