Professional Web Applications Themes

Get Primary Key - ASP.NET General

How do I get the primary key of a record just enter into the database? Then pass that same primary key ID column value to another table? Example: --- Members Table --- ---Transaction Table--- MemberID TranactionID FirstName MemberID LastName DateTime etc. etc. The transaction table is suppose to get the memberID of the member table on submit button click....

  1. #1

    Default Get Primary Key

    How do I get the primary key of a record just enter into the database?
    Then pass that same primary key ID column value to another table?

    Example:
    --- Members Table --- ---Transaction Table---
    MemberID TranactionID
    FirstName MemberID
    LastName DateTime
    etc. etc.

    The transaction table is suppose to get the memberID of the member table on
    submit button click.


    Leon Shaw Guest

  2. #2

    Default Re: Get Primary Key

    I'm using MS SQL 2000 back end, and asp.net/vb.net/visual studio.net to
    program my interface. So all I have to do is create a store procedure to
    get the primary key of the members table to pass that value to the
    transaction table?
    (I want every transaction to relate to a valid member. Plus, I want this to
    happen on a button click event, inside a transaction.)

    "S. Justin Gengo" <sjgengoaboutfortunate.com> wrote in message
    news:OtLW3hWTDHA.3796tk2msftngp13.phx.gbl...
    > Leon,
    >
    > It depends on what type of database you are using.
    >
    > If it's SQL Server use a stored procedure and try this just after your
    > insert statement:
    >
    > SELECT Identity AS MemberId
    > Return
    >
    > Unfortunately there is no equivalent for an access database.
    >
    >
    > --
    > S. Justin Gengo, MCP
    > Web Developer
    >
    > Free code library at:
    > [url]www.aboutfortunate.com[/url]
    >
    > "Out of chaos comes order."
    > Nietzche
    > "Leon Shaw" <vnalitymsn.com> wrote in message
    > news:urHJ6dWTDHA.560TK2MSFTNGP10.phx.gbl...
    > > How do I get the primary key of a record just enter into the database?
    > > Then pass that same primary key ID column value to another table?
    > >
    > > Example:
    > > --- Members Table --- ---Transaction Table---
    > > MemberID TranactionID
    > > FirstName MemberID
    > > LastName DateTime
    > > etc. etc.
    > >
    > > The transaction table is suppose to get the memberID of the member table
    > on
    > > submit button click.
    > >
    > >
    >
    >

    Leon Shaw Guest

  3. #3

    Default Re: Get Primary Key

    The primary key is a column. Every record has one.
    --
    HTH,

    Kevin Spencer
    Microsoft MVP
    ..Net Developer
    [url]http://www.takempis.com[/url]
    Big things are made up of
    lots of little things.

    "Leon Shaw" <vnalitymsn.com> wrote in message
    news:eTjgrXXTDHA.3144tk2msftngp13.phx.gbl...
    > But how will it get the current member primary key value when other
    records
    > also exist in that table?
    > "Kevin Spencer" <kevintakempis.com> wrote in message
    > news:eFtr6LXTDHA.940TK2MSFTNGP11.phx.gbl...
    > > If you use a DataSet, load the table in, add a new record, populate it,
    > and
    > > update the data source, you can read the primary key value from the
    > > DataTable.
    > >
    > > --
    > > HTH,
    > >
    > > Kevin Spencer
    > > Microsoft MVP
    > > .Net Developer
    > > [url]http://www.takempis.com[/url]
    > > Big things are made up of
    > > lots of little things.
    > >
    > > "Leon Shaw" <vnalitymsn.com> wrote in message
    > > news:urHJ6dWTDHA.560TK2MSFTNGP10.phx.gbl...
    > > > How do I get the primary key of a record just enter into the database?
    > > > Then pass that same primary key ID column value to another table?
    > > >
    > > > Example:
    > > > --- Members Table --- ---Transaction Table---
    > > > MemberID TranactionID
    > > > FirstName MemberID
    > > > LastName DateTime
    > > > etc. etc.
    > > >
    > > > The transaction table is suppose to get the memberID of the member
    table
    > > on
    > > > submit button click.
    > > >
    > > >
    > >
    > >
    >
    >

    Kevin Spencer Guest

Similar Threads

  1. Primary Scratch & Windows Primary Paging file?
    By Tommy Oberst in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 14
    Last Post: April 15th, 10:26 PM
  2. Select Primary Key
    By akcreative in forum Coldfusion Database Access
    Replies: 8
    Last Post: March 31st, 02:09 AM
  3. Primary Key Violation
    By James in forum ASP Database
    Replies: 2
    Last Post: June 22nd, 08:43 PM
  4. Add primary key
    By Simon Gorski in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 20th, 11:00 PM
  5. What is the difference with or without ON [PRIMARY]
    By Andreas Klemt in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 11th, 04:23 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139