Joining table or using a view

[Guest]

I have a situation where I need to join numerous tables in order to display
data to the user. The user will be allowed to update the information.
I am creating my data adapter and dataset in Visual Studio. However, Visual
Studio will not create insert, update, or delete commands for this dataset. I
understand this is because I have linked tables.

Are there any options to do my query another way so Visual Studio will
create the update, insert, and delete commands? I was hoping to be able to
avoid having to manually write these.

I was wanting to use a sql view, but that may not be possible. asp.net web
application using sql server 2000 database

 

[Val Mazur \(MVP\)]

Hi,

Even if DataAdaper doe not generate action queries automatically for you it
does not mean you cannot specify your own actions for the InsertCommand,
DeleteCommand and UpdateCommand properties of the DataAdapter. If you do
this than it will work

 

[William \(Bill\) Vaughn]

We've discussed this before. VS's CommandBuilder (used behind the scenes)
can't handle any but the simplest of queries. Most folks (using SQL Server
or Oracle) create their own stored procedures to handle this problem. I also
discuss this in my book(s).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________