private void FillGrid() { LoginBAL _objBAL = new LoginBAL(); SqlDataReader dr = _objBAL.GetUsers(); grdLoginUsers.AutoGenerateColumns = false; grdLoginUsers.Rows.Clear(); int count = 0; while (dr.Read() == true) { count++; grdLoginUsers.Rows.Add(dr[0].ToString(), dr[1], "*****", dr[3], dr[4], Convert.ToDateTime(dr[5]).ToString("dd,MMMM,yyyy")); } tbxCount.Text = count.ToString(); }