joinview in 2005

[Rick Elbers]

How abou joinview in 2005 ?
Its needed

 

[Cor Ligthert [MVP]]

Rick,

Why, do you want to create something as this?

Making the sample data is in this sample much more work than showing the
joined view

http://www.vb-tips.com/default.aspx?ID=5fd5a8cf-54dc-4946-a193-8a9529b2b38b

I hope this helps,

Cor

 

[Rick Elbers]

Cor,

I dont understand the character of your reaction.
In your sample you write out relations in code.
Your sample is absolutely not scalable for big joins.
Besides it does nothing about insert/update.
The idea of a joinview or updatable view is that
insert/update/get/fill are arranged for you from
a view on related tables.
In VS2005 the dataset copies the
relations for you, but you have to write the
insert and update statements yourself either
in stored procs or in code.


Thats why I want something like that.

Rick

 

[W.G. Ryan - MVP]

Sounds good, drop me an email and maybe we can write one. I've been wanting
one for a while myself. WilliamRyan At Gmail Dot Com