Results 1 to 2 of 2

Thread: [02/03] inserting data in database

  1. Jun 22nd, 2006, 10:20 PM #1
    puresmile
    puresmile is offline

    Thread Starter
    Addicted Member
    Join Date
    Apr 2006
    Posts
    244

    [02/03] inserting data in database

    i'm trying to create new user in my application. Data would be enter in sql server 2000.

    personal info of that user would be in one table while login info would be in separate table.these are present on a single web form. Also in both tables; userId is present and these are related with each other through it, if one is entered other should be automatically inserted. now i'm confused how to insert this data?
    Reply With Quote Reply With Quote
  2. Jun 24th, 2006, 11:41 AM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: [02/03] inserting data in database

    Create a stored procedure which will insert the data into both tables inside a single transaction.

    Then, call the stored procedure from your code passing the parameters it needs in.

    Read this tutorial for how to use ADO.NET

    http://samples.gotdotnet.com/quickst...teCommand.aspx
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width