does your id get's incremented in database successfully ?
if yes then you can get autoincremented id while inseration.
here is script.
insert into sample values('w','r') SELECT @@Identity as test
The test column will return newly inserted auto incremented value.
fectch the value and assign it to textbox.