I am using Gridview (Hierarchy) to display data from the database Northwind with a small modification:
- table Orders has following columns: OrderID, OrderDate
- table Details has: DetailsID, OrderID, ProductID, Quantity, UnitPrice, Total (Total is one column in Gridview using expression)
- table Products has: ProductID, ProductName, TaxID
- table Tax has: TaxID, Tax
The Orders table is parent table and the Details table is child table. With the ProductID and GridviewComboboxColumn I can display ProductName from the Products table, but I don't know how to get the Tax value from table Tax using the same method to complete the goal: Total=Quantity*UnitPrice*(1+Tax).
Do you have any idea to do that?
Any help would be appreciated.
Thanh Ho
- table Orders has following columns: OrderID, OrderDate
- table Details has: DetailsID, OrderID, ProductID, Quantity, UnitPrice, Total (Total is one column in Gridview using expression)
- table Products has: ProductID, ProductName, TaxID
- table Tax has: TaxID, Tax
The Orders table is parent table and the Details table is child table. With the ProductID and GridviewComboboxColumn I can display ProductName from the Products table, but I don't know how to get the Tax value from table Tax using the same method to complete the goal: Total=Quantity*UnitPrice*(1+Tax).
Do you have any idea to do that?
Any help would be appreciated.
Thanh Ho