How can we insert 100 records @ a time without using for loop into the databse
Answers were Sorted based on User's Feedback
Answer / answerme
If we need to copy data from one table to another we may
use "insert into" statement.
Please elaborate the qusetion, from where do we need to
insert the records?
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / raja
simply you can use sqlbulkcopy to copy entire set to
database.
or
send datatable as a parameter to the stored procedure, in
SP simply u can merge the table with actual table.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / vinodh kumar
if you are inserting values from another table. then you can use this.
insert into table name
select <columns> from <table1>
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / harshal parab
We can insert multiple records using a xml string.
This will also save the roundtrips to the database.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / natraja
convert your data as XML and use OpenXML concept in your sp
Is This Answer Correct ? | 2 Yes | 2 No |
To make insert query and with the excel sheet you can also
insert the record at a time.
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / sudhir
By use of SQLcommandbuilder, Sqldataadapter and Dataset u can direct update or insert whole datatable or dataset onto database by useinf sqldataadapter.update(datatable/dataset) method
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / 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 |
Answer / kiran tukaram mandhare
or use while loop to insert those record
OR
u can use file uploader to do this
as u can create a .csv file of those 100 records and just
upload this file in runtime and using button click event
just write the code using file stream reader to insert
those records into database
Is This Answer Correct ? | 1 Yes | 7 No |
What is use of abstract class in c#?
Why do we need oops in c#?
What are the boolean data types in c#?
Can you declare the override method static while the original method is non-static?
Why var is used in c#?
Explain the feature of c# language?
What is anonymous methods in c#?
What is difference between interface inheritance and class inheritance ?
Why does my windows application pop up a console window every time I run it?
How do I port "synchronized" functions from visual j++ to c#?
What?s the advantage of using System.Text.StringBuilder over System.String?
what is the meaning of Object lifetime in OOPS