Table 1 To Table2

Need Some help - - Having trouble transfering Data from Table1 =(BOrdersTest) to Table2=(BOrdersTest2) using Stored Procedure - Same Database.When I run the page & then check Table2, - Table2 receives a (Null) value entered into column (FullName). Thank You... Here is the Code & Stored Procedure I using. void Page_Load(object sender, EventArgs e) { SqlConnection conTest; string FullName; string strInsert; SqlCommand cmdInsert; SqlParameter parmLastName; conTest = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); cmdInsert = new SqlCommand( "TransferTest3", conTest ); cmdInsert.CommandType = CommandType.StoredProcedure; SqlParameter parameterparmLastName = new SqlParameter("@ID", SqlDbType.Int, 4); parameterparmLastName.Direction = ParameterDirection.Output; cmdInsert.Parameters.Add(parameterparmLastName); parmLastName = cmdInsert.Parameters.Add("@FullName", SqlDbType.NVarChar); parmLastName.Size = 40; parmLastName.Direction = ParameterDirection.Output; conTest.Open(); cmdInsert.ExecuteNonQuery(); conTest.Close(); Response.Write("New Product Added!"); DataGrid1.DataSource = GetBOrdersTest(); DataGrid1.DataBind(); }//-----------------------------------Below is the Stored Procedure-----------------------------------------------------------------------// CREATE PROCEDURE TransferTest3

(

@FullName NVarChar(50)OUTPUT,@ID INT OUTPUT)

ASSelect

      @ID = ID,      @FullName = FullName

From BOrdersTestWhere ID=@ID

BEGIN

INSERT INTO BOrdersTest2

(FullName)VALUES(@Fullname)

SELECT    @ID = @@Identity

END

GO