UI goes in not responding state while copying huge amount to data using SqlBulkCopy.writeToServer() method.

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

i am using SqlBulkCopy Class to copy 4500000 records from MS access to SQL server(from client to server), the process ends successfully but the UI goes in not responding state, i have used a progress bar to show the progress of copying data, it also stops incresing...and at the end of process, suddenlly shows 100% copletion of process, and data coped successfully. what should i do to make UI and progress bar active?

Posted 25-Apr-12 18:55pm

MahaKh

Updated 25-Apr-12 19:00pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

**JF2015** · Answer 1 · 2012-04-25T19:20:00

Solution 1

You should create a thread and do the SqlBulkCopy in there instead of doing it in the main thread which freezes the user interface.

Posted 25-Apr-12 19:20pm

JF2015

Comments

MahaKh 26-Apr-12 1:49am

yes, i have done exactly the same thing, i have made a thread behind a button click, in this thread a function is passed, and in that function, the actual method is called which contains SqlBulkcopy.writeToserver() call.... the ode runs perfectly for 100000 records, as it goes uo to 200000 records, UI stops responding.

[no name] 26-Apr-12 6:37am

Since you did not post any code demonstrating your problem, how are we supposed to know?