SqlBulkCopy

Question

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

Sri Kanth · Answer

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(VarcharDecimals) 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 Kadiyala · Answer

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