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
18154 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 is dependency injection in simple words?

917

What .exe means?

886

What is function c#?

901

What is string empty?

896

Why should you override the tostring() method?

1038

What are the principles of delegation?

938

Explain manifest & metadata in c#.

1006

What is the default value of datetime in c#?

969

What is windows form in c#?

1022

Explain circular reference in c#?

935

What is dapper in c#?

942

what is difference between is and as operators in c#?

986

What is instantiating a class?

926

Explain use of abstract and sealed classes in c#?

846

Can I fly with a loop recorder?

902