public List <StudentAssignment> getListOfAnswer(int lesson, string Username) { List <StudentAssignment> stlist = new List <StudentAssignment>(); try { con.Open(); SqlCommand cmd = new SqlCommand("select QuestionNo,Answer,DatabaseName from StudentAssignment where LessonNo=" + lesson + "and UserName='******'", con); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { StudentAssignment up = new StudentAssignment(); up.QuestionNo = sdr["QuestionNo"].ToString(); up.Answer = sdr["Answer"].ToString(); up.DatabaseName = sdr["DatabaseName"].ToString(); stlist.Add(up); } con.Close(); return(stlist); } catch (Exception ex) { return(null); } }
public string InsertAssignment(StudentAssignment sp) { try { con.Open(); string q = "insert into StudentAssignment (UserName,AssignmentID,classID,DatabaseName,QuestionNo,Answer,LessonNo)" + " values (@User,@assID, @ClassID,@DatabaseName,@QuestionNo,@Answer,@LessonNo)"; SqlCommand cmd = new SqlCommand(q, con); cmd.Parameters.AddWithValue("@User", sp.UserName); cmd.Parameters.AddWithValue("@assID", sp.AssignmentID); cmd.Parameters.AddWithValue("@ClassID", sp.classID); cmd.Parameters.AddWithValue("@DatabaseName", sp.DatabaseName); cmd.Parameters.AddWithValue("@QuestionNo", sp.QuestionNo); cmd.Parameters.AddWithValue("@Answer", sp.Answer); cmd.Parameters.AddWithValue("@LessonNo", sp.LessonNo); cmd.ExecuteNonQuery(); con.Close(); return("SuccessFul"); }catch (Exception ex) { return(ex.ToString()); } }