multi threading using VB.net

Question

3.00/5 (1 vote)

See more:

Hi, I am very new to multi threading. my requirment is read the data from DB(universe DB) and create the report and export to excel. there might muliple report created say 10 to 15 reports
Here what i have to do is two threads 1) read the data from DB for reports 2)with each data create excel
And these process should work as background process.
Pls help, any idea to do this is deeply appreciated.

Thanks in Advance.

Posted 4-Jul-11 0:35am

Member 8056507

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)

OriginalGriff · Answer 1 · 2011-07-04T00:46:00

Solution 1

That doesn't make a whole load of sense: why have two threads doing this? Why not have a thread (from the BackgroundWorker[^] pool) for each report? Then it keeps the related tasks together - each thread reads data, create report, export to excel, end thread.
Otherwise, you have to pass data between the threads, presumably using some form of queue - it's much easier to handle if the thread handles the whole task, particularly as the next stage can't start until the previous one is complete.

Posted 4-Jul-11 0:46am

OriginalGriff

Comments

Member 8056507 4-Jul-11 6:53am

@OriginalGriff - Thanks for ur response. Why i thought of 2 thread is, querying the data from DB also time consuming and with generating the report. So while the thread is generating a report(as excel) let the other thread queries the data from DB. Both the thread should be Synchronized. Any other idea is also welcomed.

OriginalGriff 4-Jul-11 6:56am

Why go to that complexity? If you use them as background threads and an operation is slow, then others can "get in" and do something - they won't all lock up waiting for the DB read to finish.

Member 8056507 4-Jul-11 7:00am

thanks OriginalGriff - Can u pls provide me a optimal solution for this ?

i not sure how to work with threads. If u have any code samples pls help with it.

OriginalGriff 4-Jul-11 7:06am

If you follow the original link, MSDN provides sample code which will help!

Member 8056507 4-Jul-11 7:17am

thanks. i will have a look.

Thanks again.

Member 8056507 4-Jul-11 7:45am

@OriginalGriff - i want to loop around the DB query for couple of time. when i get the first response from DB i will start creating the report. Before the report get completed the the it is started quering for the next report data from DB. I used 'For' loop for call the query .

Can you tell me how to resolve this .

Thanks.