Comments by Lay_Kay (Top 9 by date)

Where (in the script) can I execute the INSERT command? Please advise.

I also have the following coding:

 con.Open();
 cmd1.ExecuteNonQuery();

 Personel_Grid.DataBind();
 con.Close();

 lbl_Email.Visible = true;
 lbl_Email.Text = "The Personnel Process started.";


 txtFirstName.Text = "";
 txtLastName.Text = "";
 txtTitle.Text = "";
 txtManager.Text = "";
 txtEmail.Text = "";
 txtPhone.Text = "";
 txtEffective_Date.Text = "";
 lbl_Success.Text = "";
}

Isn't MAX(ID) getting the latest record?

SqlCommand cmd1 = new SqlCommand
(
     "INSERT INTO Users.[Employee] VALUES " + 
     " (@txtFirstName, @txtLastName, @txtTitle, @txtEmail, @txtPhone, 
 @txtEffective_Date, " +
            " @Email_Access_Boolean, @Remote_Access_Boolean, @Employee_Access_Boolean, " +
            " @Parking_Access_Boolean, @Security_Risk_Boolean, @Authorize_Purchase_Boolean, " + 
            " @Point_Contact_ID, @txtManager, @Dept_ID)", 
             con
);

I thought this is already inserting records. Please advise. Thanks!

Never mind.... I discovered where my problem was.