Industrial Graphics Database integration

Hello gents, can industrial graphics be used to query a database? I don’t want to have to query through the cicode and want to run it on the industrial graphics editor directly. Is it possible?

  • This doesn't answer your question directly, however, as another option, the native graphics builder has a tool called Database Exchange. This can show/edit/query a database in a grid view.

  • Hi William,

    There is no native grid control offered with Plant SCADA's Industrial Graphics to nicely display results etc.

    I've never actually done this but I guess you could write a script to make a connection and execute a command. e.g.

    dim myConn as System.Data.SqlClient.SqlConnection;
    dim myCommand as System.Data.SqlClient.SqlCommand;
    dim mySQLReader as System.Data.SqlClient.SqlDataReader;
    
    myConn = new System.Data.SqlClient.SqlConnection("add connectionstring here");
    myConn.Open();
    myCommand = new System.Data.SqlClient.SqlCommand("SELECT TOP 10 FROM things", myConn);
    mySQLReader = myCommand.ExecuteReader();
    while(mySQLReader.Read())
    {
    	...
    }

    However, I don't have advice on whether it actually works, error handling or responsiveness or how to display the results.