Check read and unread message in ASP.NET
<p>If the user has not yet accessed the message, it remains bold ("unread") and the number should be show how many message unread . If the user clicks the link and accesses it, it goes from bold to unbold ("read")</p>

<p><a href="https://i.stack.imgur.com/oPiUV.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oPiUV.jpg" alt="enter image description here"></a>
.aspx code:</p>

<pre><code>&lt;li&gt;&lt;a href="ContactForm.aspx"&gt;&lt;span class="icon16 icomoon-icon-envelop"&gt;&lt;/span&gt;&lt;span class="txt"&gt;Contact Forms&lt;/span&gt;&lt;/a&gt;&lt;span class="notification" id="txtContactCount" runat="server"&gt;0&lt;/span&gt;&lt;/li&gt;
</code></pre>

<p>c# code:</p>

<pre><code>string ContactCount = system.GetDataCell("Select Count(*) from TBLCONTACTFORM");
txtContactCount.InnerText = ContactCount.ToString();
</code></pre>

<p>now its working but it show only total message</p>