You can find a complete guide to bulk copy data from anywhere to SQL within your C# application.
http://www.codeproject.com/cs/database/SqlBulkCopy.asp
http://www.c-sharpcorner.com/UploadFile/mahesh/BulckCopyAdoNet2008192005135138PM/BulckCopyAdoNet20.aspx