joining tables or view

Discussion in 'ASP .Net' started by =?Utf-8?B?TWlrZSBNb29yZQ==?=, Jul 7, 2005.

  1. 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
    =?Utf-8?B?TWlrZSBNb29yZQ==?=, Jul 7, 2005
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. JJ297

    Trouble joining 3 tables

    JJ297, Aug 24, 2007, in forum: ASP .Net
    Replies:
    5
    Views:
    373
    Steve
    Aug 24, 2007
  2. AVL

    joining two tables

    AVL, Jul 22, 2008, in forum: ASP .Net
    Replies:
    1
    Views:
    332
    Christiano Donke
    Jul 23, 2008
  3. Peter

    Joining tables from 2 datasets

    Peter, Jun 6, 2009, in forum: ASP .Net
    Replies:
    4
    Views:
    394
    Peter
    Jun 8, 2009
  4. Artur Niesporek

    joining 3 tables in dataset

    Artur Niesporek, Apr 2, 2004, in forum: ASP .Net Datagrid Control
    Replies:
    5
    Views:
    266
    Jeffrey Tan[MSFT]
    Apr 9, 2004
  5. Parthiv Joshi
    Replies:
    1
    Views:
    646
    Samuel L Matzen
    Jul 6, 2004
Loading...

Share This Page