what is efficent way to upload bulk(more no. of records) excel file in c#.net

Question

0.00/5 (No votes)

See more:

C#3.0

C#

Please let me have some efficint bulk excel file upload and insert into database table at a single go.

Posted 21-Feb-11 0:08am

preethipriya523

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

J a a n s · Answer 1 · 2011-02-21T01:09:00

Solution 2

You can read all the contents to a DataTable and then use SqlBulkCopy[^] class to insert it into the table.

There are a couple of articles in CP for helping you..
SQL Bulk Copy with C#.Net[^]
Transferring Data Using SqlBulkCopy[^]

Posted 21-Feb-11 1:09am

J a a n s

#realJSOP · Answer 2 · 2011-02-21T00:10:00

Solution 1

The BEST way to do it is to create a stored procedure that accepts one row of data at a time, and then call it from your C# code.

Google is your friend.

Posted 21-Feb-11 0:10am

#realJSOP

Comments

Robert Rohde 22-Feb-11 2:26am

He was asking about efficiency. I think he already tried doing it row by row and this is too slow for him...

what is efficent way to upload bulk(more no. of records) excel file in c#.net

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

what is efficent way to upload bulk(more no. of records) excel file in c#.net

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us