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

Howmany five tracing levels in System.Diagnostics.TraceSwitcher? Why they are using?

959


What is the implicit name and type of the parameter that gets passed into the class set method?

819


Why do we use virtual methods in c#?

897


What is the benefit of using interface in c#?

933


How do I create a delegate/multicastdelegate?

921


What is regex replace in c#?

948


Explain the difference between and xml documentation tag?

842


Can you pass parameters to destructors?

981


What do multicast delegates mean?

931


Explain the security with aop?

1004


How can you read 3rd line from a text file?

949


What are the advantages of properties in c#?

905


What is the use of getcommandlineargs() method in c#.net?

915


What are PE(Portable Executable)?

953


What are the types of attributes in c#?

903