Hi,
I have created a web program that will import data into a SQL database. The data to be imported is just one field, but there will be hundreds of thousands to be imported at a time. At the moment I create a data table from the data in the file and then use the SqlBulkCopy command to insert them into the database. I was just wondering if this was the most efficient way of doing this and also if there was anyway of informing the user after every 10,000 records imported the total imported so far?
Cheers.
I have created a web program that will import data into a SQL database. The data to be imported is just one field, but there will be hundreds of thousands to be imported at a time. At the moment I create a data table from the data in the file and then use the SqlBulkCopy command to insert them into the database. I was just wondering if this was the most efficient way of doing this and also if there was anyway of informing the user after every 10,000 records imported the total imported so far?
Cheers.