How can we insert 100 records @ a time without using for loop into the databse
- 10 Answers
- 16579 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
What are the three types of predicates?
Write the difference between TypeOf and GetType?
What is var c#?
Why static constructor is parameterless in c#?
Does main have to be static c#?
What is readline c#?
What does namespace mean?
Can we override constructor in c#?
What do you mean by the delegate in c#?
What is difference between ilist and list in c#?
What is bitwise operator in c#?
What are the benefits of using generics?
Give examples for value types?
What type is string in c#?
What is the use of static members with example using c#.net.
