Sign Up Login


  1. Categories >> Software >> Microsoft Related >> C Sharp
  2. Suggest New Category

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

Question Posted / raja

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

How do you determine whether a string represents a numeric value?

712

What is an enumerator c#?

699

Is char * null terminated?

709

How do I use the 'using' keyword with multiple objects?

710

What is the difference between and xml documentation tag?

728

Is c# used for frontend or backend?

806

Can we have multiple threads in one app domain?

695

What is the meaning of int parse in c#?

701

Can a struct inherit from another struct or class in c#?

698

Is ram a heap?

687

explain the nature of the assembly work?

2315

How do you specify a custom attribute for the entire assembly (rather than for a class)?

725

What is visual c# net?

669

What do you mean by casting a data type?

705

What does return do in for loop?

666