title: How to decode HTML content from database in ASP.Net Page
body: <p>I retrieved HTML content from my Db in ASP.net page but all tags are showed in my page as follow</p>
  
  <pre><code>&lt;p&gt;fdvdfb &lt;strong&gt;fbgdfbd&lt;/strong&gt; &lt;em&gt;fbfgbggggggggggggggggggggg&lt;/em&gt;&lt;/p&gt;
  &lt;p&gt;iuiononknonbn&lt;/p&gt;
  &lt;p&gt;khbkinniln&lt;/p&gt;
  </code></pre>
  
  <p>But it is not fair! How can I remove these tags? And show my text as they inserted?</p>
  
  <p>My code is:</p>
  
  <pre><code>string query = "SELECT TOP 1[Text] FROM [News] ORDER BY Id DESC";
  string conString = ConfigurationManager.ConnectionStrings["mycs"].ConnectionString;
  using (SqlConnection con = new SqlConnection(conString))
  {
      using (SqlCommand cmd = new SqlCommand(query, con))
      {
          con.Open();
          using (SqlDataReader sdr = cmd.ExecuteReader())
          {
              if (sdr.Read())
              {
                  txtHTMLContent.Text = sdr["Text"].ToString();
              }
              sdr.Close();
          }
          con.Close();
      }
  }
  </code></pre>
  
  <p>And</p>
  
  <pre><code>&lt;asp:TextBox ID="txtHTMLContent" runat="server" TextMode="MultiLine" Width="100%"/&gt;
  </code></pre>