Multi-relational tables in a dataset....

  • Thread starter Thread starter rmorvay
  • Start date Start date
R

rmorvay

I have three tables in a dataset that I need to relate. I know how to
relate two tables but going beyond that is, quite frankly, beyond me. Any
insight? Here is the C# code that I did for a two table relate. I need to
relate TerritoryExceptionColumns as well:

DataColumn[] TerritoryColumns;
DataColumn[] TerritoryExceptionTypeColumns;
DataColumn[] TerritoryExceptionColumns;

TerritoryColumns = new DataColumn[]
{dsTerritory2.Tables["Territory"].Columns["TerritoryID"],
dsTerritory2.Tables["Territory"].Columns["ExceptionType"]};

TerritoryExceptionTypeColumns = new DataColumn[]
{dsTerritory2.Tables["TerritoryExceptionType"].Columns["TerritoryID"],
dsTerritory2.Tables["TerritoryExceptionType"].Columns["ExceptionType"]};

TerritoryExceptionColumns = new DataColumn[]
{dsTerritory2.Tables["TerritoryException"].Columns["TerritoryID"],
dsTerritory2.Tables["TerritoryException"].Columns["ExceptionType"]};

DataRelation drelTerritory = new DataRelation("Territory",
TerritoryColumns, TerritoryExceptionTypeColumns);
dsTerritory2.Relations.Add(drelTerritory);

Thanks in advance.
 
Is this somthing that can't be done or maybe I didn't explain my problem
well enough? I am in a crunch mode so any assistance would greatly be
appreciated.

Thanks,
 
Did you try to create two relations through the parent table "TerritoryColumns" and associate the two children(TerritoryExceptionTypeColumns, TerritoryExceptionColumns) tables through the parent table?

DataRelation drelTerritoryExceptionTypeColumns = new DataRelation("drelTerritoryExceptionTypeColumns",
TerritoryColumns, TerritoryExceptionTypeColumns);
dsTerritory2.Relations.Add(drelTerritoryExceptionTypeColumns );

DataRelation drelTerritoryExceptionColumns = new DataRelation("drelTerritoryExceptionColumns",
TerritoryColumns, TerritoryExceptionColumns);
dsTerritory2.Relations.Add(drelTerritoryExceptionColumns);


rmorvay said:
Is this somthing that can't be done or maybe I didn't explain my problem
well enough? I am in a crunch mode so any assistance would greatly be
appreciated.

Thanks,

--
rmorvay


rmorvay said:
I have three tables in a dataset that I need to relate. I know how to
relate two tables but going beyond that is, quite frankly, beyond me. Any
insight? Here is the C# code that I did for a two table relate. I need to
relate TerritoryExceptionColumns as well:

DataColumn[] TerritoryColumns;
DataColumn[] TerritoryExceptionTypeColumns;
DataColumn[] TerritoryExceptionColumns;

TerritoryColumns = new DataColumn[]
{dsTerritory2.Tables["Territory"].Columns["TerritoryID"],
dsTerritory2.Tables["Territory"].Columns["ExceptionType"]};

TerritoryExceptionTypeColumns = new DataColumn[]
{dsTerritory2.Tables["TerritoryExceptionType"].Columns["TerritoryID"],
dsTerritory2.Tables["TerritoryExceptionType"].Columns["ExceptionType"]};

TerritoryExceptionColumns = new DataColumn[]
{dsTerritory2.Tables["TerritoryException"].Columns["TerritoryID"],
dsTerritory2.Tables["TerritoryException"].Columns["ExceptionType"]};

DataRelation drelTerritory = new DataRelation("Territory",
TerritoryColumns, TerritoryExceptionTypeColumns);
dsTerritory2.Relations.Add(drelTerritory);

Thanks in advance.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-relational tables in a dataset.... 1
Data Relations 1
Creating Relations with 3 tables 1
Error when using System.Data.Relations.Add 5
Data binding combo box to a datagrid 3
ADO.NET DataRelation 1
filtering with data relations 3
Index 2 is not non-negative and below total rows count. 1

Back
Top