Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DataSet and Calculated Field
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
C# 3.0
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01398230
Message ID:
01398256
Views:
50
This message has been marked as a message which has helped to the initial question of the thread.
May be DataColumn.Expression Property works for you,
I'm not sure about the relation between the tables in your DataSet.

http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression(vs.71).aspx

* "PARENT/CHILD RELATION REFERENCING
*
* A parent table may be referenced in an expression by prepending the column name with Parent. For example, the Parent.Price references the parent table's column named Price.
*
* A column in a child table may be referenced in an expression by prepending the column name with Child. However, because child relationships may return multiple rows, you must include the reference to the child column in an aggregate function. For example, Sum(Child.Price) would return the sum of the column named Price in the child table."


> If I want to display Total Price as Qty * Price where Qty comes from one table and Price comes from another, what should I do with my > DataSet/TableAdapter?
Previous
Reply
Map
View

Click here to load this message in the networking platform