How to mark records in gridview as read and unread
<p><a href="https://i.stack.imgur.com/xs8yC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xs8yC.png" alt="enter image description here"></a></p>

<p>This is my GridView1. I want the latest record to be highlighted and after user click the authorization no(which user viewed the record in next page), the row will not be highlighted (means after the user view the record, the row is back to normal, no highlight no bold font).</p>

<p>My current progress is,
I have created new bit field in my database named ReadStatus, and defaulted to 0
Next, I need to do the onrowdatabound coding in order to implement this.</p>

<p>first question is, do i need to read the bit column(ReadStatus) as I read all this column?AuthorizationNo, ProductID,Name,Qty,---(ReadStatus)??
should I read ReadStatus in this code?</p>

<pre><code>           / /READING RECORD FROM TABLE TRACK_ITEM
            while (reader.Read())
            {
                MerchantProduct merchantProduct = new MerchantProduct();
                merchantProduct.TxID = reader["TxID"].ToString();
                merchantProduct.ProductID = reader["ProductID"].ToString();
                merchantProduct.Name = reader["ProductName"].ToString();
                merchantProduct.Qty = Convert.ToInt32(reader["Qty"]);

                listLatestProduct.Add(merchantProduct);
            }
            return listLatestProduct;
</code></pre>

<p>second is, can anyone show me the proper way to code in onrowdatabound?</p>

<pre><code>    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
           //Tried many code here but none is working 
    }
</code></pre>

<p>Thank you.</p>