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 func c#?

988


What are Namespaces?

1337


What are constructors in c#?

955


How does c# generics and c++ templates compare?

913


What is attribute and reflection in c#?

988


Is everything an object c#?

924


Are there constructors in c sharp?

956


What is a private class in c#?

1105


What is default class in c#?

914


What is get set in c#?

969


What is a delegate in c#?

932


Explain what are three test cases you should go through in unit testing?

933


What is console readkey ()?

946


Can constructor be private c#?

875


List down the commonly used types of exceptions in .net

884