Hello I have an application that connects to sql database
my application is multithread.
When I run the application it loads top 500k data and stores it in #temp1(connection1), i can browse, search and select data, while my thread is running and storing the other 501 to 1m data in #temp2(connection2).
My problem is temporary table can be seen in there own session. what is the other way to this? so that i can get the 501k to 1m data.

Recommended Answers

I'm not sure that I understand what it is that you mean by "own session"

If you mean that you want to merge the two datatables together so that they can be displayed in the same DataGridView control, then you would use the

Jump to Post

All 2 Replies

Hi i am new in this forum. Thanks

I'm not sure that I understand what it is that you mean by "own session"

If you mean that you want to merge the two datatables together so that they can be displayed in the same DataGridView control, then you would use the DataTable.Merge method. Perform the merge in your worker thread's completed event handler.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.