Complex update Command objects

Discussion in 'ASP .Net' started by Mervin Williams, Apr 16, 2004.

  1. If my SelectCommand points to a stored procedure containing a select
    statement which joins two tables, my DataTable will consist of the results
    of the query. Here is my statement:
    SELECT * FROM Contact INNER JOIN Company_Contact ON Contact.contact_id =
    Company_Contact.contact_id WHERE (Company_Contact.company_id = @companyid)

    Well, since that is the case, how do I write my UpdateCommand,
    InsertCommand, and DeleteCommand objects to update the two different tables
    contained in the join query?

    Thanks in advance,

    Mervin Williams
     
    Mervin Williams, Apr 16, 2004
    #1
    1. Advertising

  2. Mervin Williams

    Sharon Guest

    hi marvin.
    i suggest that you post you question at:
    microsoft.public.sqlserver.programming
    you will probably get a better answer there.

    "Mervin Williams" <> wrote in message
    news:uVxQ%23N$...
    > If my SelectCommand points to a stored procedure containing a select
    > statement which joins two tables, my DataTable will consist of the results
    > of the query. Here is my statement:
    > SELECT * FROM Contact INNER JOIN Company_Contact ON Contact.contact_id =
    > Company_Contact.contact_id WHERE (Company_Contact.company_id = @companyid)
    >
    > Well, since that is the case, how do I write my UpdateCommand,
    > InsertCommand, and DeleteCommand objects to update the two different

    tables
    > contained in the join query?
    >
    > Thanks in advance,
    >
    > Mervin Williams
    >
    >
    >
     
    Sharon, Apr 17, 2004
    #2
    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. news.amnet.net.au
    Replies:
    1
    Views:
    604
    =?UTF-8?b?TMSByrtpZSBUZWNoaWU=?=
    Apr 13, 2004
  2. Stanimir Stamenkov
    Replies:
    2
    Views:
    794
    Stanimir Stamenkov
    Oct 25, 2005
  3. Robert Mark Bram
    Replies:
    0
    Views:
    718
    Robert Mark Bram
    Feb 4, 2007
  4. Kottiyath

    How complex is complex?

    Kottiyath, Mar 18, 2009, in forum: Python
    Replies:
    22
    Views:
    802
  5. prakash
    Replies:
    2
    Views:
    631
    prakash
    Apr 11, 2005
Loading...

Share This Page