feewosmesia
New Member
I am doing a SQL Insert to populate my table. I have a unique generated ID in one table that I would like to use in another table for my join. Is this possible?.NET MVC --\[code\]using (SqlConnection connect = new SqlConnection(connections)){ SqlCommand command = new SqlCommand("ContactInfo_Add", connect); command.Parameters.Add(new SqlParameter("name", name)); command.Parameters.Add(new SqlParameter("address", address)); command.Parameters.Add(new SqlParameter("Product", name)); command.Parameters.Add(new SqlParameter("Quantity", address)); command.Parameters.Add(new SqlParameter("DueDate", city)); connect.Open(); command.ExecuteNonQuery();}\[/code\]SQL SERVER --\[code\]ALTER PROCEDURE [dbo].[Contact_Add]@name varchar(40),@address varchar(60),@Product varchar(40),@Quantity varchar(5),@DueDate datetimeAS BEGIN SET NOCOUNT ON; INSERT INTO DBO.PERSON (Name, Address) VALUES (@name, @address) INSERT INTO DBO.PRODUCT_DATA (PersonID, Product, Quantity, DueDate) VALUES (@Product, @Quantity, @DueDate)END\[/code\]The code inserts fine. Just how do I pull the Auto-generated PersonID to use in PRODUCT_DATA?