Get Primary Key

[Leon Shaw]

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]

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" <sjgengo@aboutfortunate.com> wrote in message
news:OtLW3hWTDHA.3796@tk2msftngp13.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" <vnality@msn.com> wrote in message
> news:urHJ6dWTDHA.560@TK2MSFTNGP10.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]

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" <vnality@msn.com> wrote in message
news:eTjgrXXTDHA.3144@tk2msftngp13.phx.gbl...

> But how will it get the current member primary key value when other

records

> also exist in that table?
> "Kevin Spencer" <kevin@takempis.com> wrote in message
> news:eFtr6LXTDHA.940@TK2MSFTNGP11.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" <vnality@msn.com> wrote in message
> > news:urHJ6dWTDHA.560@TK2MSFTNGP10.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.
> > >
> > >

> >
> >

>
>