Show Trend with data from MS SQL-server

[bjornidar]

Hi,

is it possible to connect the Trendview to another database than the integrated Compact edition?

Per now we are logging great amounts of data to a SQL database and wish to show this in a Trend in iX.

[Ron L.]

Yes, this should be possible with C# scripting by incorporating compatible methods from the System.Data.SqlClient Namespace.
http://msdn.microsoft.com/en-us/library ... 90%29.aspx

The SqlConnection class can connect to SQL Server Databases.
http://msdn.microsoft.com/en-us/library ... 90%29.aspx

Not all methods are available in the .NET Compact Framework so look for the mobile icon next to the method to see if it's available.
http://msdn.microsoft.com/en-us/library ... 90%29.aspx

You can use "Script Modules" in iX Developer Manual to put C# script.

Once you have written script to retrieve the data, copy values into tags by referencing the "Globals.Tags" area in iX Developer (i.e. Globals.Tags.Tag1.Value = 5;). Then make sure the tags you are updating are used by the TrendChart.