DataRelations Link Question Win [C#]

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MikeY - 12 Oct 2007 15:58 GMT

Hi Everyone,

Is it possible to link more than two tables together? My sample that works
perfectly fine (but only the two links) is as follows:

DataRelation TableDetail =
DB_DataSet.Relations.Add("EMPLOYEE_ASSIGNED_LEVELS",
DB_DataSet.Tables["EMPLOYEE_ZONE"].Columns["EMP_ID"],
DB_DataSet.Tables["EMPLOYEE_ASSIGNED_LEVELS"].Columns["EMP_NUMBER"]);

Any and all help is appreciated

Thanks

MikeY

Reply to this Message

MikeY - 12 Oct 2007 16:21 GMT

Yippy I found it......I think. Anyhow heres the code that I've located.

DataRelation TableDetail =
DB_DataSet.Relations.Add("EMPLOYEE_ASSIGNED_LEVELS",new
DataColumn[]{DB_DataSet.Tables["EMPLOYEE_ZONE"].Columns["EMP_ID"]},new
DataColumn[]
{DB_DataSet.Tables["EMPLOYEE_ASSIGNED_LEVELS"].Columns["EMP_NUMBER"],DB_DataSet.Tables["EMPLOYEE_INTRANET"].Columns["EMP_NUMBER"]});

I know there is also another way to do it, but, this is good for me

Thanks eveyone.

> Hi Everyone,
>
[quoted text clipped - 11 lines]
>
> MikeY

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...