joining tables or view

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,769
Messages
2,569,579
Members
45,053
Latest member
BrodieSola

Latest Threads

Top