//list the log-in sessions according to the selected criterion private void BuildListBox(int userID, int groupID, DateTime time1, DateTime time2, bool cvs) { string pad = " "; try { DataSet sessionData = InternalAdminDB.SelectSessionHistory(userID, groupID, time1, time2); DataTable sessionHistory = sessionData.Tables[0]; if (sessionHistory.Rows.Count == 0) { lblResponse.Text = Utilities.FormatWarningMessage(" No sessions found for your criteria."); lblResponse.Visible = true; } else { StringBuilder buf = new StringBuilder(); buf.AppendLine(String.Format("{0,-14}{1,-18}{2,-10}{3,-10}{4,-26}{5,-24}", "User Name", "Create Time", "End Time","Modify","Group","Client")); DataTableReader dtr = new DataTableReader(sessionHistory); while(dtr.Read()) { //buf.Append(dtr.GetInt64(0) + pad); buf.Append(String.Format("{0,-12:12}", dtr.GetString(1)) + pad); if(!dtr.IsDBNull(2)) buf.Append(DateUtil.ToUserTime(dtr.GetDateTime(2), CultureInfo.InvariantCulture,userTZ,"g") +pad); else buf.Append(String.Format("{0,-9:9}", "Not Set") + pad); if (!dtr.IsDBNull(3)) buf.Append(DateUtil.ToUserTime(dtr.GetDateTime(3), CultureInfo.InvariantCulture, userTZ, "T") + pad); else buf.Append(String.Format("{0,-8}", "Not Set") + pad); if (!dtr.IsDBNull(4)) buf.Append(DateUtil.ToUserTime(dtr.GetDateTime(4), CultureInfo.InvariantCulture, userTZ, "T") + pad); else buf.Append(String.Format("{0,-8}", "Not Set") + pad); string tmp = dtr.GetString(5); if (tmp != null && tmp.Length > 24) tmp = tmp.Substring(0, 24); buf.Append(String.Format("{0,-24}",tmp) + pad); tmp = dtr.GetString(6); if (tmp != null && tmp.Length > 24) tmp = tmp.Substring(0, 24); buf.Append(String.Format("{0,-24}",tmp)); buf.AppendLine(); } txtLoginDisplay.Text = buf.ToString(); } } catch (Exception ex) { lblResponse.Text = Utilities.FormatErrorMessage(" Cannot retrieve UserSessions. " + ex.GetBaseException()); lblResponse.Visible = true; } }