Use Datagrid Control get SQL data.

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.

  • 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.