Datarelations - C# / C Sharp

pleasehelp

Hi,

Could someone please explain how the datarelation object
works. I am getting very confused.

I have 3 tables

Document
Employee
EmployeeToDocumentRelationship

I have related these tables together (i think) using the
DataRelation object. I am unsure on how to traverse
throught the related data and find all documents that
belong to a specific employee.

please help..
thanks,

pleasehelp :0)

Nov 15 '05 #1

Subscribe Post Reply

2307

Uwe Hafner

Theoretically speaking (you don't provide much information):

Depending on what you set up as whatevers parent you should be able to get
Parent/ChildRows with DataRow.GetParentRow/GetParentRows or
DataRow.GetChildRow/GetChildRows.
And with this you can get from one employee row to multiple rows in
employeetodocumentrelationship and from there to one of the associated
document rows.

So actually you don't need the Relationship Object to travel through the
tables after you have created the relationships.

hth
Uwe

"pleasehelp" <pl********@hotmail.com> schrieb im Newsbeitrag
news:04****************************@phx.gbl...

Hi,

Could someone please explain how the datarelation object
works. I am getting very confused.

I have 3 tables

Document
Employee
EmployeeToDocumentRelationship

I have related these tables together (i think) using the
DataRelation object. I am unsure on how to traverse
throught the related data and find all documents that
belong to a specific employee.

please help..
thanks,

pleasehelp :0)

Nov 15 '05 #2

Similar topics

DataRelations

by: Les | last post by:

I have a problem getting Dataset.WriteXml() to create a nested xml realtionship. All I get is an inline xsd (all nodes are children of the root). Documentation says to use...

.NET Framework

relationship tables and datarelations

by: niv | last post by:

Hi, I am unsure on how to retrieve data from tables 2 tables that are related through a relationship table.. TableOne -------- TableOneID TableOneDesc

C# / C Sharp

DataRelations?

by: Kevin | last post by:

Hi All this is going to be a lengthy questions do please bear with me.... I have a database that has three tables - Employees, ShiftHeader,ShiftDetails Now the employees table holds the...

C# / C Sharp

Making DataRelations Look Nice

by: Randy | last post by:

I have two DataTables in a DataSet. I create a DataRelation between two like-typed columns in the first and second tables, and it works exactly as expected. Unfortunately, the default behavior...

C# / C Sharp

DataRelations defined for DataSet but not showing up.

by: Fleckman | last post by:

I have a DataSet with 14 DataTables and 18 Relationships that were defined within Visual Studio .NET 2003. Everything looks OK in the visual development environment, i.e. when I preview the DataSet...

C# / C Sharp

DataRelations vs Joins

by: Phil Townsend | last post by:

I have seen a lot on ADO.NET data relations, but my jury is still out on the benefits of coding a data relation vs. using a join in a stored procedure. I know there is more overhead when using the...

C# / C Sharp

Navigating datarelations

by: Lerp | last post by:

Hi all, I have a dataset made up of 3 tables that is bound to a datalist. On the itemdataBound event I call a sub that grabs a value (an id value) from the current row being outputted, queries...

ASP.NET

XmlDataDocument from DataSet with Nested DataRelations

by: George Durzi | last post by:

I have a DataSet with 3 tables, and two DataRelations dsSubs.Tables.TableName = "Subscriptions" dsSubs.Tables.TableName = "AccountManagers" dsSubs.Relations.Add "AccountManagers_Subscriptions",...

ASP.NET

DataRelations and GridView

by: Carlos Albert | last post by:

Hello everybody, I'm using some gridviews with datalists inside template columns. Now, for each datalist I'm calling a method returning a dataset (depending from a column from the gridview). ...

ASP.NET

Datarelations

by: Vajrala Narendra | last post by:

hi all, am working in asp.net i am using two data entry screens for parent and child tables. i heard that using datarelations we can achieve this using single screen. is it ppossible? please...

.NET Framework

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++