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
- 10 Answers
- 18082 Views
- IBM, I also Faced
- E-Mail Answers
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
I was trying to use an out int parameter in one of my functions. How should I declare the variable that I am passing to it?
What is enumerable in c#?
What do u mean by delegation?
Is as keyword in c#?
What is executenonquery c#?
What is meant by collections in c#?
What is predicate builder?
Why do we use static class in c#?
Is datetime immutable c#?
Why do we use delegates?
What are the types of constructors?
How do you pronounce c#?
List some of the classes used by system.data namespace?
windows c# using datagridview in edit form sql server
What is executescalar in c#?
