Loading

SqlBulkCopy

Sri Kanth

Hi, i am a developer(Asp.net 2.0 + C#.net) I have one problem. In button Click event i am trying to Insert 24 Records at a Time.(Calling Stored Procedure for 24 Times) i.e i have one DB call(Stored Procedure) for every Record The Other Alternate for this is use SqlBulkCopy i have tried but i am unable to solve the issue as i don't have idea about this process if I could get the code for both ADO.Net and Database. Thanks in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sri Kanth18y ago
Hi,

I have gone through this link and the things mentioned in this article are Database name and Table name. In my scenario i have 24 rows of Data(Varchar,Decimals) i have to validate each input before submiting. I am Using Stored Procedures in the Backend. So, Can any one give the solution for this Scenario

Thanks in Advance.
Vijaya Kadiyala18y ago
Hi

Check out the below link

http://www.c-sharpcorner.com/UploadFile/mahesh/BulckCopyAdoNet2008192005135138PM/BulckCopyAdoNet20.aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com