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 the file extension for c#?
Is it possible to have different access modifiers on the get/set methods of a property in c#?
how background thread access to ui control?
Is the following code legal?
Is dictionary reference type c#?
Explain clr in brief.
What is a console application in c#?
What is the use of xmlserializer?
What is response redirect in c#?
Can hashtable have duplicate keys in c#?
What is use of private class in c#?
To create a localized application which namespaces are necessary?
How do you read an Excel sheet in C#?
What is console based application?
What is the default boolean value in c#?