Hello,
I am loading my csv file into the sql server using C#.net. I want to skip any errors occured during this insert and display those at the end of the process. It should not affect the insert process of remaining rows. Also, I want to show how many rows got inserted?"

how do I do this?
Thanks in advance.

Hi there,

That's a pretty broad question, and largely depends on the code you have and the technology you are using. E.g. starting an Integration Service package from C# is quite different from looping through the lines in a text file.

Typically, you loop through each item, and try to insert it (or manually validate the data before you try the insert). If you do this in a try/catch block, it's easy to keep track of failures, and the number of successful rows.

Vague answers, but that's because the question is vague... ;)

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.