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.
semicolon 0 Light Poster
Jeevan Saral 0 Newbie Poster
Hi i am new in this forum. Thanks
TnTinMN 418 Practically a Master Poster
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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.