private void GetTotalRecords()
    {
        string where = "Sender=N'{0}' and Status='0'";
        where        = string.Format(where, CurrentUser.UserName);
        if (this.WildCard != "")
        {
            where = where + string.Format(" And (Title like N'%{0}%' or Body like N'%{0}%' or Recipient  like N'%{0}%')", WildCard);
        }


        TotalRecords = MessageBLL.GetMessageTotalItems(where).ToString();

        PagingControl1.TotalRecords = int.Parse(TotalRecords);
    }