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

Is c# still popular?

934


What is an inheritance ?Give an example in which inheritance is used?

1078


What is hashtable in c# net with example?

995


Is c sharp free?

969


Why do we need a singleton class?

1080


What is an escape sequence in c#?

1017


Is list immutable in c#?

932


What is dbml file in c#?

1045


What is list collection in c#?

1011


Is c# or c++ better for games?

898


What is the function of .IsDescendent()?

1064


What is the difference between private and protected in c#?

973


What do you mean by thread safe in c#?

928


What is c# used for in the industry?

949


Explain the difference between class and interface in .net?

911