Inserting into 2 MS access Tables using asp.net c# RSS

• • Reply
  

  kenny90

  Member

  5 Points

  4 Posts

  Inserting into 2 MS access Tables using asp.net c#

  Dec 01, 2011 02:57 PM|LINK

  Hi i'm trying to inset informaiton into 2 tables from a form. I know i need an insert statement because i have it inserting into one table witht the command below. but i can't see to insert the info into 2 tables.

   

  INSERT INTO User([userNo],[userName]VALUES (?,?)

  • Moved by mbanavige on Dec 01, 2011 11:29 PM
• • Reply
  

  salman beher...

  All-Star

  30721 Points

  5871 Posts

  Re: Inserting into 2 MS access Tables using asp.net c#

  Dec 01, 2011 03:49 PM|LINK

  Hi,

  check here for details...

  http://www.codeproject.com/KB/cs/MultipleInsertsIn1dbTrip.aspx

  http://www.daniweb.com/web-development/aspnet/threads/109323

  "…Mark As Answer" if my reply helpful to you…”
  Sincerely,
  Salman
  
  • Edited by salman behera on Dec 01, 2011 03:49 PM
• • Reply
  

  hans_v

  All-Star

  35986 Points

  6550 Posts

  Re: Inserting into 2 MS access Tables using asp.net c#

  Dec 01, 2011 07:39 PM|LINK

  kenny90

  but i can't see to insert the info into 2 tables

  You can't do that in one statement. You need to write two statements to insert the data into 2 tables.

  • Marked as answer by decker dong - msft on Dec 08, 2011 02:18 AM