Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 anonymous method in c#?

869


Why do we need dependency injection in c#?

911


What is session state in asp net c# with example?

862


What is the full form of GAC? Explain its uses?

985


Is c# scripting language?

874


Which programming language is best for desktop applications?

920


Write a syntax for writing a event delegate.

925


What is the meaning of extention?

966


How to prevent the error while updating ui control from another thread?

953


What are the benefits of using windows services:

1021


What is xml comments in c#?

869


In .NET which is the smallest unit of execution?

1046


What is Event - Delegate?

1056


What are the boolean data types in c#?

1000


What is yield break in c#?

893