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

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

Question Posted / raja

10 Answers
18460 Views
IBM, I also Faced
E-Mail Answers

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 are extender provider components?

944

What is ulong in c#?

1078

What is a ienumerator?

966

What are the commonly used i/o classes?

1003

Can you explicitly call a destructor?

983

what are the different ways a method can be overloaded?

958

What is meant by unicode characters?

1037

Why we use dll in c#?

1013

What is dll file in c#?

1012

What is a protected class in c#?

1001

What is namespace in oop?

980

Which framework is best for desktop application?

1053

What is the difference between list and arraylist c#?

1122

What is gridview c#?

953

How long does it take to learn c# programming?

963