Adding an Array of ParentColumns in a DataTable

's Computer Specifications

Here is my code:
mds.Relations.Add( _

New DataRelation( _

relationName:="relPaidSwipe", _

parentColumn:=mds.Tables("PaidvsJob").Columns("EmpNumber"), _

childColumn:=mds.Tables("Swipes").Columns("EmpNumber"), _

createConstraints:=False))

I am trying to make a relationship on 2 columns instead of just one. Is
this posible?

's Computer Specifications

What do U mean by making relation on one Column??
U can set up relations only on two columns

Regards
Mahesh

>-----Original Message-----
>Here is my code:
>mds.Relations.Add( _
>
>New DataRelation( _
>
>relationName:="relPaidSwipe", _
>
>parentColumn:=mds.Tables("PaidvsJob").Columns
("EmpNumber"), _
>
>childColumn:=mds.Tables("Swipes").Columns("EmpNumber"), _
>
>createConstraints:=False))
>
>I am trying to make a relationship on 2 columns instead
of just one. Is
>this posible?
>
>
>.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
breaking up a String into an array of chars and adding to datatable	Paulers	Microsoft VB .NET	6	15th Jan 2007 02:31 AM
Error when adding array to datatable	=?Utf-8?B?YQ==?=	Microsoft C# .NET	2	6th May 2005 07:24 PM
Retrieving datarows using DataTable.Select method and adding it to new DataTable	C.Anand via DotNetMonster.com	Microsoft ADO .NET	4	4th Apr 2005 05:21 PM
How can I use real SQL on a DataTable? i.e. not array of rows using a filter... as in DataTable.Select	Dan V.	Microsoft C# .NET	3	1st Jul 2004 03:06 PM
Adding to a Datatable. Error: Index was outside the bounds of the array	Gerry Viator	Microsoft ADO .NET	2	10th Jun 2004 05:54 PM