I have a text file that contains hundreds of records in a specific format.
My question is what is a good approach to load these accounts in the database?
1). Is it a better approach to load these accounts one by one by calling the insert statement for each account in a While loop?
eg: While(newrow.Readline!= null)
//Read the values
2). or is it better to load all these accounts in a collection or a datatable and then push them all at once to the database using dataadapter.Update
3). Or if there is a better approach?
Please advise, which approach is normally used to load bulk accounts.