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
What is jagged array?
How can I process command-line arguments?
When should we use sealed class in c#?
What is asp net c# corner?
What is delegate in c# interview questions?
Is array reference type in c#?
What is windows form in c#?
What is a float?
Is int a struct in c#?
If a child class instance is created, which class constructor is called first - base class or child class?
Illustrate serialization?
What is method and function in c#?
What is the purpose of constructor in c#?
Can c# inherit multiple classes?
Is array value type in c#?