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
Does the variables of a private class-level inherited?
What is hashset c#?
What is .cshtml file?
What is a console application in c#?
What is the difference between as and is operators in c#?
How to override a function in c#?
What is an Interface in C#?
Explain use of abstract and sealed classes in c#?
What the different phase/steps of acquiring a proxy object in webservice?
What is difference between === and ==?
Can a constructor be private in c#?
What is exe in c#?
What is method overriding in c#
What is the delegate in c#?
What is difference between events and delegates?