Get the Identity by ExecuteScalar

rania Magdy

Dears,

I want to Insert row and retrieve the Identity : SqlCommand cmd1 = new SqlCommand( "INSERT INTO SalesTable (ProductId, CustomerId, Qty, SaleDate, SalePrice, SalePolicy, Notes) " + " VALUES (@ProductId, @CustomerId, @Qty, @SaleDate, @SalePrice, @SalePolicy, @Notes)" + " SELECT SCOPE_IDENTITY() ", dbModule.con); each time the execute scaller return Empty (Guid should contain 32 digits .....) I tried many ways with both Scallar and Reader would u plz tell me the write way to code this

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
well i recommend you todo the following

Declare @yourNewId Uniqueidentifier
SET @yourNewId = SCOPE_IDENTITY()
return @yourNewId
rania Magdy17y ago
Its uniqueidentifier, and the default value of this row newid() i want to get this inserted id
Roei Bar17y ago
well according to your post it seems like you are getting the Identity Back the problem is that its not a uniqueidentifier

if you are using "uniqueidentifier" then you need to return the inserted newid()

just put the code you wrote directly in SQL Server and you will see the return type