i m making one asp.net page. in that page there is three text boxes called id, response id, and email. same columns is in sql server table called info. In table "info" for id column i have assigned " isidentity" = yes. its created auto number like 1,2,3..... and so on for id column. now i want to assign autonumber for response id column also. sql server allows only one autonumber in one table.
User will be enter only email id in texbox called email. and rest response id column should fill automaticaly in table on click of submit button. please see the attachments. please help.