How can we insert 100 records @ a time without using for loop into the databse

Answer Posted / raja

simply you can use sqlbulkcopy to copy entire set to
database.

or

send datatable as a parameter to the stored procedure, in
SP simply u can merge the table with actual table.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dll in c#?

496


Explain inheritance in c#?

540


Explain About web methods and its various attributes

500


Can abstract classes be final?

489


What is final keyword in c#?

513






When should I throw an exception?

546


How we can create an array with non-default values?

501


Why do we use generics in c#?

530


How Reflection is used and what it's significance ?

513


What is difference between sleep () and wait ()?

484


How many bits is int32?

485


How many bytes is an int in c#?

499


What is bit in c#?

520


How to do and Apply Themes to Datagrid,Lable,Textbox,etc., in C#.NET 2005 Windows Application? (like who we will do themes in ASP.NET using .CSS and .SKIN files). Urgent!!

1675


What is difference between constants and readonly in c#?

476