Affiliate Form

I need to create a form that will be embedded into another site that prospective affiliates to the site will sign up. The form must be Secure. The form will submit to the database after error checking has been done and then a Thank You page will give the Affiliate their new ID number which will be read from the database ID row which should start at around 6000. An email will also be sent confirming their non-sensitive information and their affiliate ID number. This should be in Asp.net and Sql 200/2005.