title: how to retrieve all data from sql server 2008 in asp.net
body: <p>how to retrieve all data from sql server 2008 to my page in asp.net this is aspx code :</p>
  
  <pre><code>    &lt;asp:Image ID="ImageProfile" runat="server" Width="20" Height="25" /&gt;
      &lt;asp:Label ID="LabelName" runat="server" Text=""&gt;&lt;/asp:Label&gt;&lt;br /&gt;
      &lt;asp:Label ID="LabelAddress" runat="server" Text="Label"&gt;&lt;/asp:Label&gt;
  </code></pre>
  
  <p>and this is my aspx.cs code :</p>
  
  <pre><code>    string cs=ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
          using (SqlConnection con=new SqlConnection(cs))
          {
              con.Open();
              SqlCommand cmd = new SqlCommand("SELECT * FROM member",con);
  
              SqlDataReader dr = cmd.ExecuteReader();
  
                  while (dr.Read())
                  {
                      ImageProfile.ImageUrl=dr["image"].ToString();
                      LabelName.Text=dr["Name"].ToString();
                      LabelAddress.Text=dr["Address"].ToString();
  
                  }
  
          }
  </code></pre>
  
  <p>but my output just one result whereas I have more than three columns 
  thanks for any guide </p>