When you inserting data using SqlCommandBuilder...

Discussion in 'ASP .Net' started by Rico Alexander, Oct 23, 2003.

  1. is there a way to retrieve the value of an autoincrement column inserted in
    the database?
    Rico Alexander, Oct 23, 2003
    #1
    1. Advertising

  2. Rico Alexander

    zPaul Guest

    Select @@Identity right after the insert. You will get the autoincrement
    value.


    "Rico Alexander" <> wrote in message
    news:...
    > is there a way to retrieve the value of an autoincrement column inserted

    in
    > the database?
    >
    >
    zPaul, Oct 23, 2003
    #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. microsoft.private.windows.netserver.setup

    Stored Procedures with SQLCommandBuilder

    microsoft.private.windows.netserver.setup, Mar 6, 2004, in forum: ASP .Net
    Replies:
    5
    Views:
    2,818
    microsoft.private.windows.netserver.setup
    Mar 6, 2004
  2. =?Utf-8?B?SmltIFJleW5vbGRz?=

    SqlCommandBuilder

    =?Utf-8?B?SmltIFJleW5vbGRz?=, May 12, 2005, in forum: ASP .Net
    Replies:
    4
    Views:
    2,637
    =?Utf-8?B?SmltIFJleW5vbGRz?=
    May 16, 2005
  3. Bhavesh
    Replies:
    0
    Views:
    408
    Bhavesh
    Jul 16, 2007
  4. microsoft.private.windows.netserver.setup

    Datagrid and SqlCommandBuilder

    microsoft.private.windows.netserver.setup, Mar 6, 2004, in forum: ASP .Net Datagrid Control
    Replies:
    0
    Views:
    112
    microsoft.private.windows.netserver.setup
    Mar 6, 2004
  5. microsoft.private.windows.netserver.setup

    Stored Procedures with SQLCommandBuilder

    microsoft.private.windows.netserver.setup, Mar 6, 2004, in forum: ASP .Net Datagrid Control
    Replies:
    0
    Views:
    123
    microsoft.private.windows.netserver.setup
    Mar 6, 2004
Loading...

Share This Page