I have seen examples and samples such that you can show the Related Tables Data in the current Table.
The syntax is something like:
' add a new calculated column to the Categories table, with the number of child
' products
ds.Tables("Categories").Columns.Add("ProductsCount", GetType(Integer), _
"Count(Child(CatProducts).ProductID)")
However, whenever I try this or any other such expression, I get an InvalidCast Exception in a Typed DataSet.
I want to know if anyone has tried this and has it worked
Also which is better, to show the value in this manner or do a join in the SQL statement.
Any help will be great.
--Rythm
Typed DataSet Column Refering to Relationship
Hot Topic
- datagrid column
- Datagrid as 2DTable with labeled rows and columns
- SelectionForeColor in DataGridViewLinkColumn
- Problem about deployment
- How to convert a .NET Application(WinForm) to Active X Control
- DataView.RowFilter Problem
- use generic collection as datasource?
- Searching files in step-by-step mode
- loading treeview from a DataBase
- Remote Server Is Unreachable - New Install
Windows Forms
- how to implement this custom user control---listview and progressbar ?
- Formdesigner doesn't display controls
- Position of context menu
- Can't if (e.Control.TextChanged != null) , throws exception
- Problem inserting a new record with VB 2005 using a table adaptor and SQL 2005 Express
- painting shapes from vs.net windows form to visio
- weird writing text to file question
- Form Hangs on Controls.Remove
- Set forms-start
- Monitoring arrow keys events
Typed DataSet Column Refering to Relationship