sovain

Display / Add Datasets

Discussion created by sovain on Jun 8, 2012
Latest reply on Jun 13, 2012 by andreas

Hi All,

 

I am really stuck in finding a solution for the next issue.

 

In .NET Application I need to trend couple of tags as well as some ODBC Data.

 

In a result, I want to make a specific SQL query and add the (Time Value ) result to Trend.

 

If you look at the code, I add a Dataset with the Dataprovider: pI_dataset,  that is pre-defined on my form with QueryTableAdapter; test query is ok.

 

But when I lunch it sinusoid-tag is trending well,  "EOH_POSITIONS_CURRENT" - say "Invalid Data".

 

Am I doing something wrong?

 

Is there any other way to retrieve real PI Data without using ODBC and connect it to trend ?

 

Thank you

 

Oleg

 
....
lifing_Define_hourlyeoh_Trend = (PBSymLib.Trend)lifing_Trend_hourlyeoh_Display.Symbols.Add(PBObjLib.pbSYMBOLTYPE.pbSymbolTrend);

//----add Dataset - here is problem
lifing_Trend_hourlyeoh_Display.Datasets.Add("EOH_POSITIONS_CURRENT", pI_dataset, true, 1, true, 1);



lifing_Define_hourlyeoh_Trend.AddTrace("sinusoid");
//----try to add DS - data
 lifing_Define_hourlyeoh_Trend.AddTrace("EOH_POSITIONS_CURRENT.Value");

 

Outcomes