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 / varsha motwani

You can use "Update()" method of DataAdapter which will
accept Dataset


DataAdapter.Update Method (System.Data.Common).
This will internally call loop for insertion and it will
hit the database evry time for each record.
Another way is to aceppt input as string and pass record in
form of XML and parse the XML in stored procedure and
perform Insert

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the file extension for c#?

959


Is it possible to have different access modifiers on the get/set methods of a property in c#?

925


how background thread access to ui control?

980


Is the following code legal?

926


Is dictionary reference type c#?

775


Explain clr in brief.

895


What is a console application in c#?

901


What is the use of xmlserializer?

815


What is response redirect in c#?

846


Can hashtable have duplicate keys in c#?

827


What is use of private class in c#?

921


To create a localized application which namespaces are necessary?

926


How do you read an Excel sheet in C#?

935


What is console based application?

906


What is the default boolean value in c#?

897