A friend of mine today asked me "Can we Insert more than one row in the database without iterating for each row ?". Indeed the question asked by her is really a good one ! So I tried to find out the solution, I have heard that ADO.NET 2.0 Bulk Copy Option can copy bulk of data from one datasource to another with less round trips, but I was not sure that this option will work with my friends' problem.
So I googled and got a very good article by Mahesh Chand on C# Corner. The article is simple, precise and very comprehensible.
Link:
http://www.c-sharpcorner.com/Code/2004/June/BulkCopy.asp
I hope this might be helpful to you.