/// <summary>Return a list of open bugs</summary> public BugTracker[] GetIssueList() { List <BugTracker> bugs = new List <BugTracker>(); string connectionString = File.ReadAllText(@"D:\Websites\bugTrackerConnect.txt"); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string sql = "SELECT bg_id, bg_short_desc FROM bugs WHERE (bg_status <> 5) ORDER BY bg_id DESC"; using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { BugTracker bug = new BugTracker(); bug.bugID = (int)reader["bg_id"]; bug.description = (string)reader["bg_short_desc"]; bugs.Add(bug); } } } connection.Close(); } return(bugs.ToArray()); }
/// <summary>Return a list of open bugs</summary> public BugTracker[] GetIssueList() { List<BugTracker> bugs = new List<BugTracker>(); string connectionString = File.ReadAllText(@"D:\Websites\bugTrackerConnect.txt"); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string sql = "SELECT bg_id, bg_short_desc FROM bugs WHERE (bg_status <> 5) ORDER BY bg_id DESC"; using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { BugTracker bug = new BugTracker(); bug.bugID = (int)reader["bg_id"]; bug.description = (string)reader["bg_short_desc"]; bugs.Add(bug); } } } connection.Close(); } return bugs.ToArray(); }