title: loop throw gridview1 rows to add contents in other gridview2
body: <p>I have this code and I already try debugging, there are no other problem but only one thing I dont know is how to read through the next row from the Gridview "aT" which I got from a Sql query result</p>
  
  <pre><code>  For Each aR As DataRow In aT.Rows
          Dim AltRow As DataRow = AltTbl.NewRow
          AltRow.Item(0) = aR.Item("OXLINC")
          AltRow.Item(1) = aR.Item("OXPART")
          AltRow.Item(2) = FormatCurrency(aR.Item("OXLSTP"))
          AltRow.Item(3) = FormatCurrency(aR.Item("OXCOST"))
          AltRow.Item("QtyRA") = QtyR
          AltRow.Item(5) = aR.Item("OXQTYA")
          AltRow.Item(8) = r.RowIndex
          AltRow.Item(9) = MFG
          AltTbl.Rows.Add(AltRow)
      Next
  
      If AltTbl.Rows.Count &gt; 0 Then
          GridView10.DataSource = AltTbl
          GridView10.DataBind()
          GridView10.Visible = True
          GridView7.Visible = False
      End If
  
      For Each gR As GridViewRow In GridView10.Rows
          Dim sR As DataRow = aT.Rows(0)  //Dont know what to do here
          Dim WhseTbl As New DataTable
          WhseTbl.Columns.Add("WhseID")
          WhseTbl.Columns.Add("Qty")
          For i = 1 To 10
              If RTrim(sR.Item("OXBR" &amp; i)) &lt;&gt; "" Then
                  Dim wR As DataRow = WhseTbl.NewRow
                  wR.Item(0) = sR.Item("OXBR" &amp; i)
                  wR.Item(1) = sR.Item("OXAV" &amp; i)
                  WhseTbl.Rows.Add(wR)
                  gR.BackColor = Drawing.Color.Yellow
              End If
          Next
          If WhseTbl.Rows.Count &gt; 0 Then
              Dim whseG As GridView = gR.FindControl("WhGrid")
              whseG.DataSource = WhseTbl
              whseG.DataBind()
          Else
              gR.Cells(6).Text = "Not Available"
          End If
          If sR.Item("OXQTYA") &gt;= 1 Then
              gR.BorderColor = Drawing.Color.GreenYellow
          End If
      Next
  </code></pre>
  
  <p>It only read first Row I know its obvious but I need help. I want to know what I can replace that with</p>
  
  <p>Thanks </p>