C# multiple inserts into MS SQL DB from single form
Posted on 2014-07-28
I have a user form to plan future loads for delivery in ASP.net / C#. The user pre-enters the delivery loads for the next day. Often, multiple loads are to and from the same location. I am looking for a way for the user to determine how many times the same information from one form entry is entered in to the database.
Example form entries.
LOADID Date PickupLocation Delivery Location Commodity Number of loads
If the user puts the number 10 for number of loads, the entered DATE, PICKUP, DELIVERY AND COMMODITY will be entered into the database in 10 new rows with unique LOADID's
I am not sure where to start looking for the solution to this.
Any help is appreciated.