title: How should I go about comparing all rows in a sql table against a "master record" using vb.net?
body: <p>Let's say, for example, this is a quiz where the answers are already loaded into a database from different students.  Inside of the table with various student entries containing various student's answers there is a row "masterentry" with all of the correct answers.</p>
  
  <p>What I would like to do is code a button that will pull the master row on click and compare every other row against it. Starting with the first row, every time the column matches the master entry 1 point is assigned to a declared integer.  When the row has completely been read the integer is stored in a "totalpoints" column.  Then it moves on to the next row of answers.</p>
  
  <p>I hope this makes sense the way I worded it, if there is an easier way to go about it I am open to suggestions.  I don't really need any help establishing the connection to the sql database.  Any help would be greatly appreciated, thanks in advance for anyone's time.  I can provide more details if it would be helpful.</p>