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 jagged array?

934


How can I process command-line arguments?

977


When should we use sealed class in c#?

903


What is asp net c# corner?

1294


What is delegate in c# interview questions?

1000


Is array reference type in c#?

894


What is windows form in c#?

1029


What is a float?

913


Is int a struct in c#?

904


If a child class instance is created, which class constructor is called first - base class or child class?

929


Illustrate serialization?

962


What is method and function in c#?

996


What is the purpose of constructor in c#?

858


Can c# inherit multiple classes?

958


Is array value type in c#?

1037