title: doesn't do a loop.. adding timespan from mssql database
body: <p>i need help for this code.. it is succesfully added but it doesnt loop from each database record.. i have 3 records in my DB but he only detects 1 and i use loop.. it does not loop and add to it.. any help to revise this code?</p>
  
  <p>i have 3 records from fieldname: dtr_grantotal:</p>
  
  <ol>
  <li>= 10:41:00</li>
  <li>= 01:11:00</li>
  <li><p>= 03:30:10</p>
  
  <pre><code>sqlSTR = "select * from tblTImelog where dtr_datelog Between '" &amp; DateTimePicker1.Text &amp; "' AND '" &amp; DateTimePicker2.Text &amp; "'"
  ExecuteSQLQuery(sqlSTR)
  
  _totalDays = sqlDT.Rows.Count
  
  If sqlDT.Rows.Count &gt; 0 Then
      Dim T1 As String = "00:00:00"
      Dim myRow As DataRow = sqlDT.Rows(sqlDT.Rows.Count - 1)
      Dim span1 As TimeSpan = TimeSpan.Parse(T1)
  
      For i = 0 To sqlDT.Rows.Count - 1
          Dim span2 As TimeSpan = TimeSpan.Parse(sqlDT.Rows(i)("dtr_grandtotal"))
          t1 = span1.Add(span2).ToString
      Next 
  
      MsgBox(t1)
  End If
  </code></pre>
  
  <p>he only shows from my msgbox the first.. although i added it in my for loop..</p></li>
  </ol>