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 func c#?
What are Namespaces?
What are constructors in c#?
How does c# generics and c++ templates compare?
What is attribute and reflection in c#?
Is everything an object c#?
Are there constructors in c sharp?
What is a private class in c#?
What is default class in c#?
What is get set in c#?
What is a delegate in c#?
Explain what are three test cases you should go through in unit testing?
What is console readkey ()?
Can constructor be private c#?
List down the commonly used types of exceptions in .net