Read data from the SQL format is as follows:

I think according to the field "ValueID" segmentation, combined into imagination as a variable people, according to the longitudinal to the report of time, as follows:


Before I practice (" ValueID=") method, using the select segmentation to generate a new datatable, then use a for loop data onto a new table in the final output to the datagridview above, in so doing, a small amount of data is no problem, but the amount of data of more than 100000 times, there are some efficiency is not high, a great god, and of all stripes dared ask is there a better way to split combination?
PS: the SQL query is manufacturer dedicated query, can't from the start

CodePudding user response:

One-time show 100000 is also much
Discuss this with the manufacturer, you to write SQL

CodePudding user response:

reference 1st floor Summer_djz response:

disposable show 100000 is also much
Discuss this with the manufacturer, you to write SQL

=- can't do that, software is the upper machine of Siemens WinCC
Only provide OLDDB interface for external query