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); }