title: How Can I Insert All subject marks for one student at a time ? ? Want It Dynamically bcz Subjects might be change
body: <p>i have Exam_Result table and Subject_Info table like this....</p>
  
  <pre><code>1] Exam_Result table....
  
  Resultid         numeric(18, 0)   Unchecked
  Enroll_Number    varchar(50)      Checked
  Student_Name     varchar(100)     Checked
  Course_Id        varchar(50)      Checked
  Semester         varchar(50)      Checked
  Subject_Id       varchar(50)      Checked
  MarksObtained    numeric(18, 0)   Checked
  Exam_Type        varchar(50)      Checked
  
  2] Subject_Info table....
  
  Subject_Id       varchar(20)    Unchecked
  Subject_Name     varchar(50)    Checked
  Semester         varchar(10)    Checked
  Course_Id        varchar(20)    Checked
  Course_Type      varchar(20)    Checked
  </code></pre>
  
  <p>i want to insert each sub marks at a time....for eg want to enter each sub marks of unique student Enroll_No with 11111, Course_Id = CIV and Sem = 1....</p>
  
  <pre><code>Enroll_Number 11111
  Course_Id     CIV
  Semester      1
  </code></pre>
  
  <p>here's are the subjects...i want to enter marks like this....</p>
  
  <pre><code>Subject_Id   MarksObtained
  EM           23
  SM           25
  CL           30
  </code></pre>
  
  <p>And This result must be stored into Exam_Result table....</p>
  
  <p><strong>NOTE: Subjects are not fix for every semester it might be change as per school... so i want it with dynamic solutions...</strong></p>
  
  <p>Can you plz help me how i can solve this problem..??? or any other soltuon the give it to me.... thnks in advance</p>