Industrial Graphics Database integration

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.

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.