Bulk insert in database.

Am using Sql server 2008,

i have three columns in a table.. i need to insert 50 lak records.. do i want to run loop like below or any other way..

for i as integer = 1 to 500000
'insert query
next

Have a look at the SqlBulkCopy class.