Automatically generate Auto Incremented Code from Database in ASP.Net TextBox

its shows an error while creating the procedure ..here i include my full table data...pls tell me how can i use with ur procedure with my table da..

empcode	int	Unchecked
fname	varchar(50)	Unchecked
lname	varchar(50)	Checked
age	int	Checked
dob	date	Checked
doj	date	Checked
pan	varchar(50)	Checked
company	varchar(50)	Checked
desig	varchar(50)	Checked
dept	varchar(50)	Checked
tsalary	int	Checked
image	image	Checked
gsalary	int	Checked
hra	int	Checked
conveyance	int	Checked
oallowance	int	Checked
mallowance	int	Checked
pfund	int	Checked
ptax	int	Checked
npayable	int	Checked

pls help me..how to add my table data as per your procedure