How do I build a DataRelation dynamically
The two tables in question are in memory and untyped.
The tables and primary keys are built on the fly.
The tables are populated using sqlreader
Now I want to buld a DataRelation between these two tables.
My understanding of this process is like swiss cheese. Lots of holes!
Please help me get my arms around this.
tia,
Todd
Building a DataRelation dynamically?
Hot Topic
- How to use datagrid to add other controls
- Forms Designer fails to start
- how to show message box only once in vb.net
- Get the version of setup
- some problem arised while removing a group from the listview ?
- Problem with checkbox databinding
- Winforms
- ClickOnce - multiple applications
- export the data from text file to the table in the Database
- Fixed Length Strings
Windows Forms
- PLEASE do not publish my previous post
- Image Property
- accessing resource from another assembly
- Treestyleview in a datagridview?
- Collapsible Listview control
- [VB.NET] Hiding menubar of MDI parent
- How did they achieve the Windows XP Look?
- WinForms and mini-database
- Controls arrays
- DLL Control in IE Windows Form
Building a DataRelation dynamically?
BrianHenderson
Found the problem.
Parentheses are not matched at Sum((
VS didn't catch this one.
The function works fine.
JoshZ
Receiveing this error:
Additional information: Syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier.
Based on this statement:
ds.Tables.Item("ParentTable").Columns.Add("P5Sum", GetType(Decimal), "Sum((Child(myRelation).P5)")
The "myRelation" DataRelation has five columns:
Does this mean, to use the aggregate function sum(), that the DataRelation can only have one comlumn
tia,
Todd
gsutphin11
dataSet.Relations.Add("tab_1_tab_2",
dataSet.Tables["Tab1"].Columns["p_id"],
dataSet.Tables["Tab2"].Columns["p_id"]);
there several oveloads for the Add method