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
Is c# still popular?
What is an inheritance ?Give an example in which inheritance is used?
What is hashtable in c# net with example?
Is c sharp free?
Why do we need a singleton class?
What is an escape sequence in c#?
Is list immutable in c#?
What is dbml file in c#?
What is list collection in c#?
Is c# or c++ better for games?
What is the function of .IsDescendent()?
What is the difference between private and protected in c#?
What do you mean by thread safe in c#?
What is c# used for in the industry?
Explain the difference between class and interface in .net?