In SQL, the command would be:

DECLARE @ID AS INT
SET @ID = @@Identity
INSERT INTO tbl_lmedata_equipment
(lmedata_id)
VALUES
(@id)


In ASP, VB.NET, what is the command for this? Ive tried almost everything. Visual Basic doesnt pick up the @@Identity as being anything. How do I get the auto increment variable without using the @@ Identity?
Thank you!

@@IDENTITY will work only when you are in the same connection that inserted a record. You can't make to separate calls and get it to work. Instead, build a query statement that contains both:

INSERT INTO .... ; SELECT @@IDENTITY;

Then run the query with .ExecuteScalar() and you can get the identity for the new row.

-Peter

Wow, thank you so much!! I was using the ExecuteNonQuery, it wasnt working!! ExecuteScalar works great, Thank you again so much!
:):):):):):):)