here is the link where sql transaction is used http://www.aspnettutorials.com/tutor...on-csharp.aspx

in this line
Code:
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
RegionID is entered by user rather than auto generated ,so i have same problem but only difference is that if i have auto generated what code should i write in try block .