how-to-implement-real-time-data-server-and-use-rtd-worksheet-function/CS/TestRTDClient/Form1.cs at 24.2.1+ · DevExpress-Examples/how-to-implement-real-time-data-server-and-use-rtd-worksheet-function · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
using DevExpress.XtraSpreadsheet;
using System;

namespace TestRTDClient {
    public partial class Form1 : DevExpress.XtraBars.Ribbon.RibbonForm {
        public Form1()
        {
            InitializeComponent();

            spreadsheetControl1.LoadDocument("Portfolio.xlsx");
        }

        private void barEditRefreshMode_EditValueChanged(object sender, EventArgs e) {
            RealTimeDataRefreshMode mode = (RealTimeDataRefreshMode)Enum.Parse(typeof(RealTimeDataRefreshMode), barEditRefreshMode.EditValue.ToString());
            spreadsheetControl1.Options.RealTimeData.RefreshMode = mode;
        }

        private void barEditSpinThrottleInterval_EditValueChanged(object sender, EventArgs e) {
            spreadsheetControl1.Options.RealTimeData.ThrottleInterval = Int32.Parse(barEditSpinThrottleInterval.EditValue.ToString());
        }

        private void barbButtonRefreshData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
            spreadsheetControl1.Document.RealTimeData.RefreshData();
        }

        private void barButtonRestartServers_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
            spreadsheetControl1.Document.RealTimeData.RestartServers();
        }
    }
}