ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert CSV file to table in oracle 10g from ASP.NET using ODP.NET

661367Sep 23 2008 — edited Sep 25 2008

Hi,
I was using ODP.NET for one webapplication with ASP.NET 2008.I need to insert CSV data to table in ORacle 10g.Now i am using File upload control to upload CSV to server,so i can fill dataset using this CSV and show the data in Grid.But i dont know how i can insert this to table. In Sqlclient there is one option for bulk insert(Sqlbulkcopy).I need to insert Entire CSV data to table without using Loop.How i can impliment this by using ODP.NET?If its not possible can any one gsuggets solution to do this.we want to insert data in bulk.So we canot use loop structure.If can please give me sample code.

thanks in advance.

Regards,
Sajesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2008

Added on Sep 23 2008

#and, #file, #odp-net, #oracle

4 comments

1,878 views