how to handle the database when multiusers are inserting data at same time
1.First user click on save button
2.sp_1 will be execute which is used to insert the data in table1
3.primary key value will be retrive from sp_1 to aspx.cs form.
4 sp_2 will be execute next. Which is used to inset the data in table2 with the primary key of table1
At the point 1 more than one user press Save button and only one user data is saving in database while others data is not saving.
Any solution for this.