How to insert multiple rows into sql database depending on user input?

Here is a very good example of creating stored procedures to supply the future functionality of what your wanting to do on the SQL side of things HERE:

http://blog.sqlauthority.com/2009/09/23/sql-server-insert-values-of-stored-procedure-in-table-use-table-valued-function/[^]

Then depending on where your data is coming from could be in the Stored Procedure to collect the data for the values or you would have to send in that value.

On the C# side of things, you can do many different options to loop through the data needs:

While example:
http://www.google.com/url?sa=t&rct=j&q=loops%20in%20c%23&source=web&cd=6&cad=rja&ved=0CFgQFjAF&url=http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2F2aeyhxcd(v%3Dvs.71).aspx&ei=DY7YUM20McikqQG1rYGABw&usg=AFQjCNHqyjWzbpqw721Gz5SZ44_yGXBqNw&bvm=bv.1355534169,d.aWM[^]

FOR supplied above but heres another: (Visual Studio version not relevent in this example)

http://msdn.microsoft.com/en-us/library/ch45axte.aspx[^]


Foreach, Do etc... examples:

http://msdn.microsoft.com/en-us/library/ms228598(v=vs.90).aspx[^]

Hope that helps.