Use Datagrid Control get SQL data.

Question

Hello, 
 We have a traditional intouch project without industrial graphic tool, I want to use datagrid control to display SQL table data and do some simple searches. 
 
 I find it has the property of DataSource, how to fill this parameter?

Thank you.

Richard Köhlerstrand · Accepted Answer

Hi, to do this without Industrial Graphics will be a challenge since there is no built in SQL script library that can be used to link a dataset to the ActiveX Control's DataSource property. (requires data-type DataTable/DataSet) 
 Legacy InTouch uses SQL Access manager and bindlists to link rows of data from a dataset to InTouch tags. 
 This would work much easier if you would have possibility to use Industrial Graphics, I know you state that it is not available, but could be worth exploring? 
 In legacy InTouch where a datagrid was needed, we have created our own custom ActiveX that also manages the connection and query of data to a database, and not only the display the data, but I do not know if I would recommend that today since it is not the best solution for a future-proof solution, I would expect the support for ActiveX to be removed in future versions since it is a legacy technology that becomes harder and harder to maintain supported.

Use Datagrid Control get SQL data.

Top Replies