Right now my code grabs the price from ITEM, however, I want to grab the price from Orderdet....I would I fix that in my code below?
Public Sub GetSummaryDataGrid()
Dim dv As DataView = CType(SqlShippingReport.Select(DataSourceSelectArguments.Empty), DataView)
If dv.Count > 0 Then
Dim dr As DataRowView = dv.Item(0)
Session("SHIPPEDSUMMARYTABLE") = GridView1.ToString
End If
SqlShippingReportDataTable.SelectCommand = "SELECT ITEM.ITEMNM, ITEM.DSC, ITMPRICE.PRICE" & _
"FROM ITEM INNER JOIN ITMPRICE ON ITEM.ITEMNM = ITMPRICE.ITEMNM" & _
"WHERE (ITMPRICE.ACCTNBR = ?)'" & lblAccount.Text & "'"
SqlShippingReportDataTable.SelectCommand = "SELECT QTY" & _
"FROM ORDERDET " ...
Go to the complete details ...