Getting back sql generated id's

Tech-Archive recommends: Fix windows errors by optimizing your registry

I start with an empty dataset
I then add several rows to it
I then update the SQL table with the dataset update method

The table's primary key is an identiy field so the id's are generated by SQL

how do I get the id's that were generated when the records were inserted?
Can I get them loaded back into the dataset?


.

Relevant Pages

  • Re: Getting back sql generated ids
    ... InsertCommand. ... > I then update the SQL table with the dataset update method ... > The table's primary key is an identiy field so the id's are generated by ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Getting back sql generated ids
    ... Microsoft MVP ... >I start with an empty dataset ... > I then update the SQL table with the dataset update method ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Getting back sql generated ids
    ... numbers to SQL SErver which will in turn cause valid numbers only to be ... > I then update the SQL table with the dataset update method ... > The table's primary key is an identiy field so the id's are generated by ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Express - Identity specification property - how to change
    ... FOO_ID int identity, ... Tony Rogerson, SQL Server MVP ... They are making unfortunately frequent use of the IDENTITY column in conjunction with Primary Key. ... IDENTITY has none of the properties of a data type because it is not a data type at all. ...
    (comp.databases.ms-sqlserver)
  • Re: Binding and adding rows with SQL identity column
    ... Each time you call AddNew then the DataTable generates a new ... Each time an update is done then the real primary key ... > generated by the built-in wizard in VS2003. ... > identity column on the sql table, perhaps this would all the fine and I ...
    (microsoft.public.dotnet.framework.windowsforms)