public ArrayList readAllCoreHomework() { ArrayList allCoreHomework = new ArrayList(); string query = "SELECT * from CoreHomework"; conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader re = cmd.ExecuteReader(); while (re.Read()) { Homework hw = new Homework(re["CoreHomeworkID"].ToString(), re["LastEditBy"].ToString(), re["MinutesToComplete"].ToString(), re["HomeworkTitle"].ToString()); allCoreHomework.Add(hw); } conn.Close(); return(allCoreHomework); }
public Homework readSingleCoreHomework(string id) { string query = "SELECT * from CoreHomework where CoreHomeworkID = '" + id + "'"; Homework selectedCoreHomework = new Homework(); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); //cmd.Parameters.AddWithValue("@id", id); SqlDataReader re = cmd.ExecuteReader(); while (re.Read()) { selectedCoreHomework = new Homework(re["CoreHomeworkID"].ToString(), re["LastEditBy"].ToString(), re["MinutesToComplete"].ToString(), re["HomeworkTitle"].ToString()); } conn.Close(); return(selectedCoreHomework); }