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

explain the nature of the assembly work?

2496


Which is better interface or abstract class in c#?

763


How can I develop an application that automatically updates itself from the web?

840


What is anonymous types in c#?

859


What is concrete class in c# with example?

897


In which format you can pass the value in the sleep function?

884


Okay, so an int is a value type, and a class is a reference type. How can int be derived from object?

894


4. Describe the process when we send a request URL? And who is responsible for that?

1929


What are the different types of assemblies available and their purpose?

862


what is a static constructor?

1144


How to force my .net app to run as administrator on windows 7?

917


What is xslt in c#?

817


How can I check the type of an object at runtime?

911


What is the difference between delegates and superdelegates?

855


What is use of FormBoarderStyle Propertie

872