How to save large data in Database from c# Windows App

Question

hello guys,

I am working on ERP project which is being developed in C# Windows Form Application. It is multi-tier application which has UI,Business,Data Access, Data & property layer. When I try to save data like 4 items at a time. It's taking 2.5 seconds time to execute layer in folowing order.

UI --> Business --> DataAccess .

But when it comes to Data Layer it takes more than 6-7 seconds for completing saving process. I am optimizing code which has done by my seniors. I have attatched a sample code file which consist a Save function in Data layer. Please go through it and suggest what code changes should I do to work it faster.

Thanks & Regards,

Suraj 

Answer 1

Hi Chetan,

 

Please see the below links.

 

https://pauliom.com/2009/04/30/how-to-remove-items-from-a-bound-list-box-or-how-to-avoid-operation-not-supported-on-read-only-collection/