What is the right way to load the values from the database to label?
<h2>Admin.aspx</h2>

<pre><code>       &lt;div id="valueIntroduction" class="labelarea" runat="server"&gt;   &lt;/div&gt;
       &lt;div  class="line"&gt;&lt;/div&gt;
</code></pre>

<h2>Admin.aspx.cs</h2>

<pre><code>        SqlConnection NewConn = new SqlConnection(ConfigurationManager.ConnectionStrings["SoicConnection"].ConnectionString);
        NewConn.Open();
        SqlCommand NewComm = new SqlCommand();
        SqlCommand NewComm1 = new SqlCommand();

        if (Department.Items[0].Selected)
        {
                firstPanel.Visible = true;
                myLegend.InnerText = "Informatics";
                NewComm.CommandText = "getTextHeaderINFO";

                NewComm.CommandType = CommandType.StoredProcedure;
                NewComm.Connection = NewConn;
                NewComm.CommandTimeout = 3000;
                SqlDataReader results = NewComm.ExecuteReader();

                while (results.Read())
                {
                     Response.Write(results["TEXT_CONTENT"].ToString());
                     Label valueIntroduction = results["TEXT_CONTENT"];
                }

         }
</code></pre>

<p>What I am exactly tryting is to get the value from database and loading it into a label. I am new to .net and stackoverflow. Sorry incase if I dont know how to use this forum properly.</p>
