In my code below i have lblPurchaseOrder.Text which shows the purchase order number.. However after looping through it only shows my last purchase order number. How would i fix it to show all my purchase order numbers?
Public Sub GetOrders()
SqlShippingReport.SelectCommand = "SELECT ORD1PONBR, FULLORDID FROM ORDERHDR " & _
" WHERE ACCTNBR='" & lblAccount.Text & "' and CRDT >='" & Session("StartDate") & _
"' and CRDT <='" & Session("EndDate") & "'"
Dim dv As DataView = CType(SqlShippingReport.Select(DataSourceSelectArguments.Empty), DataView)
Dim orderCount As Integer = 0
If dv.Count > 0 Then
Dim i As Integer = 0
Do Until i = dv.Count
Dim dr As DataRowView = dv.Item(i)
...
Go to the complete details ...