public List <DataManagment.task> getTasks(int appID) { List <DataManagment.task> retVal = new List <DataManagment.task>(); string command = "SELECT * FROM Task WHERE appID='" + appID + "'"; SqlCommand com = new SqlCommand(command, conn); SqlDataReader reader; conn.Open(); reader = com.ExecuteReader(); while (reader.Read()) { DataManagment.task temp = new DataManagment.task(); temp.appID = reader.GetInt32(1); temp.name = reader.GetString(2); try { temp.description = reader.GetString(3); } catch (Exception) { temp.description = ""; } try { temp.status = reader.GetInt32(4); } catch (Exception) { temp.status = 0; } retVal.Add(temp); } reader.Close(); conn.Close(); return(retVal); }
protected void Button5_Click(object sender, EventArgs e) { // Table m = (Table) Session["tb"]; Table m = Table1; List <DataManagment.task> ta = new List <DataManagment.task>(); for (int i = 1; i < m.Rows.Count; i++) { DataManagment.task temptask = new DataManagment.task(); CheckBox cb = new CheckBox(); cb = (CheckBox)m.Rows[i].Cells[0].Controls[0]; if (cb.Checked) { temptask.status = 1; } else { temptask.status = 0; } temptask.appID = Int32.Parse(Label11.Text); temptask.name = m.Rows[i].Cells[2].Text; TextBox tb = new TextBox(); tb = (TextBox)m.Rows[i].Cells[3].Controls[0]; temptask.description = tb.Text; ta.Add(temptask); } db.updateTask(ta); }