从 C# chart 中获取数据-3-526互联

这里介绍C#的修改步骤：

1. 修改连接

 DataSet ds = new DataSet();
            OleDbCommand comm = new OleDbCommand();
            OleDbDataAdapter da = new OleDbDataAdapter();
            string ConnectStr = @"Provider=WinCCOLEDBProvider.1;Catalog=AC_ZDH1_TEST#HMI#2023-V7_TLG_F_202305160510_202305250329;Data Source=ZDH1" + "\\WINCC";
            OleDbConnection conn = new OleDbConnection(ConnectStr);
            conn.Open();
            comm.Connection = conn;
            comm.CommandType = CommandType.Text;

            comm.CommandText = @"TAG:R,88,'2023-05-25 03:15:00.000','2023-05-25 03:18:00.000','TIMESTEP=15,3'"; 

            da.SelectCommand = comm;
            da.Fill(ds);
            ArchiveC = new DataView(ds.Tables[0]);

2. 显示数据

  int count = 0;
            PIDCollection = new ObservableCollection<Trends_A1>();
            while (count < 30)
            {
           
                double ProcessVariable = (double)ArchiveC[count].Row.ItemArray[2];
                PIDCollection.Add(new Trends_A1(count, ProcessVariable, ProcessVariable, ProcessVariable));
                ++count;
            }
            PIDCollectionC = PIDCollection;
            conn.Close();