title: How To Read Text File to Datagridview
body: <p>I've a project that I want to load text file to a <code>DataGridview</code>.<br>
  Data :</p>
  
  <pre><code>"#Tools Must You Have  
  Tool_1 Screwdriver T1    
  Tool_2 Screw T2   
  Tool_3 Ruler T3" 
  </code></pre>
  
  <p>I have two button(<code>btSave</code> &amp; <code>btOpen</code>) and a <code>DataGridview</code> has two columns(<code>Tools</code> &amp; <code>Name</code>)<br>
  i want to read the data to <code>DataGridview</code>, but I want skipping the line beginning with "<code>#</code>"  </p>
  
  <p>I tried it with this code</p>
  
  <pre><code>Private Sub LoadGridData(ByRef ThisGrid As DataGridView, ByVal Filename As String)
      ThisGrid.Rows.Clear()
      Dim TextLine As String = ""
      Dim SplitLine() As String
      Using objReader As New System.IO.StreamReader(Filename)
          Do While objReader.Peek() &lt;&gt; -1
              TextLine = objReader.ReadLine()
              SplitLine = Split(TextLine, " ")
              Me.DataGridView1.Rows.Add(SplitLine)
          Loop
      End Using
  End Sub
  </code></pre>
  
  <p>This code is wrong, when it's loaded, text in column is not same, only read one word "<code>Screwdriver</code>" not "<code>screwdriver T1</code>",<br>
  any solution for this ?</p>