title: is there any way to ignore reading in certain lines in a text file?
body: <p>I'm trying to read in a text file in a c# application, but I don't want to read the first two lines, or the last line. There's 8 lines in the file, so effectivly I just want to read in lines, 3, 4, 5, 6 and 7.
  Is there any way to do this?</p>
  <p><em>example file</em></p>
  <pre class="lang-sql prettyprint-override"><code>_USE [Shelley's Other Database]  
  CREATE TABLE db.exmpcustomers(  
  fName varchar(100) NULL,  
  lName varchar(100) NULL,  
  dateOfBirth date NULL,  
  houseNumber int NULL,  
  streetName varchar(100) NULL  
  ) ON [PRIMARY]_  
  </code></pre>
  <p><strong>EDIT</strong></p>
  <p>Okay, so, I've implemented Callum Rogers answer into my code and for some reason it works with my edited text file (I created a text file with the lines I didn't want to use omitted) and it does exactly what it should, but whenever I try it with the original text file (above) it throws an exception. I display this information in a DataGrid and I think that's where the exception is being thrown.</p>
  <p>Any ideas?</p>