I am looking for some advice on the following problem:
I am using a GridView and a SQLDataSource.
The problem is based around a Room Booking app I am currently writing.
When the user makes a booking, an entry must be written to the Booking
table, and x amount of entries to the BookingXref(the room keys are held
here)
How can I write muliple Inserts using a SQLDataSource in such a way that
I rollback any errors (is it possible to wrap many SQLDataSource.Inserts
in a transaction) or can someone suggest another way of doing this?
I would have used a Stored Procedure, but the rooms are variable.
Any help on this would appreciated.
Regards,
Steven
*** Sent via Developersdex http://www.developersdex.com ***