Returning the value of an identity column during / after the SQL INSERT command

Using VS 2010, with ASP.NET, and .NET 3.0, and C#...

When I use a System.Web.UI.WebControls.SqlDataSource and call its Insert() method to insert a new row, and that table has an identity column, I'd like my method to return the value of that column.

For example, in my SQL 2005 table, I've got:

Customer.Id
Customer.FirstName
Customer.LastName

Where Customer.Id is an identity colum.

When I call my method InsertNewCustomerRecord( "John", "Smith" ), I'd like to be able to return the Customer.Id that gets automatically generated in the database.

Sorry for such a roughly posed question. Let me know if I can add better detail. Thanks.

The Insert method uses the InsertCommand property...

So modify the InsertCommand to be either

INSERT Mytable (col1, col2) VALUES (@param1, @parame);SELECT SCOPE_IDENTITY();

Or (for SQL Server 2005+)

INSERT Mytable (col1, col2) OUTPUT INSERTED.IDCol VALUES (@param1, @param2);

Set the maximum value for an identity column in SQL Server 2005

I am developing an Windows pplication(using Visual Studio 2008,Sql server 2005). I have to maintain userlog information. I am having an identity column. It is working fine. But now the value of identity column is 172. Again when I try to log on I am

how to get & ldquo; ET & rdquo; of all the values of a Boolean column in a single sql

how to get "AND" of all the values of a boolean column in a single sql query. for above the o/p should be false, if all were true then o/p: true, if all/atlease one value false , then o/p: false.Try this IF EXISTS (SELECT ActiveStatus From Table

Returns the last inserted identifier without using a second request

I'm working on an ASP.NET project (C#) with SQL Server 2008. When I insert a row into a table in the database, I would like to get the last inserted ID, which is the table's IDENTITY (Auto Incremented). I do not wish to use another query, and do some

Asp.net MVC 4 Database Query returns the sql query.

I am trying to query my database to get a specific data from my database. however when I convert the query to string it doesn't return the select value, instead it returns the whole SQL Query in a string. I am stumped on why this is happening public

The SQL INSERT stored procedure does not work

Create Proc CrearNuevoAnuncio @Titulo varchar(250), @Precio int, @Descripcion varchar(250), @IDCategoria int, @IDImagen int, @Login varchar(200) AS INSERT INTO Anuncio VALUES( @Titulo, @Precio, @Descripcion, @IDCategoria, @IDImagen, @Login ) The erro

Joomla - Where to edit the SQL insert?

I'm learning to create MVC component right now. I studied the code that was created using the component creator. Now I wanna to locate the SQL insert function after the save button is click in the edit form, where does the form send to to call the in

How to increment and explicitly return the value of an identity column

Using Microsoft SQL Server 2012, I have to get the next ID of an identity column, set it to other table and return. That's how I thought it can be done: declare @NeededID as bigint select @NeededID = IDENT_INCR('Table1') update Table2 set NeededID =

Default column value based on the value of an identity column

Is it possible to have a default value based on the value of the identity column? i.e. alter table myTable add constraint df_columnX default ident_current('myTable') for columnX Is there another way? I want the current identity for the insert stateme

Unable to insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF when you are not trying to set a value for an IDENTITY column

I have a WebApi2/Entity Framework project using Code First that is throwing this error: Cannot insert explicit value for identity column in table 'Sessions' when IDENTITY_INSERT is set to OFF. This is the model: public class Session { [Key, ForeignKe

Finding a value in an array and returning a value in that row / column

I am very basic at vba so unfortunately don't have a lot of ideas of how to do this type of search and related call. I have an array like the below with each cell in the array a number from 0 to 100. I want to create a table where for every value in

Why do I get & ldquo; Unable to insert explicit value for identity column & rdquo; in LINQ to SQL when I do not specify a value for an identity column?

I have a table that looks like this: ClientID is the only identity column I have in the table. UserID is a FK to a different tables primary key. Here is my Linq to SQL insert code: public void InsertClientByUsername(string username, Entities.Client c

Related Articles