Ready to get started?

Learn more about the CData ADO.NET Provider for Streak or download a free trial:

Download Now

DataBind Streak Data to the DevExpress Data Grid

Use the CData ADO.NET Provider for Streak with the DevExpress Windows Forms and Web controls to provide Streak data to a chart.

The CData ADO.NET Provider for Streak implements standard ADO.NET data access components that can be used with third-party controls. The standard ADO.NET process for databinding can be followed to enable bidirectional access to live data from UI controls. In this article we show how to use the CData components to databind to the DevExpress Windows Forms and Web controls; you will databind to a chart that displays current data.

Use the following steps to generate a new API key for authenticating to Streak.

  1. Navigate to Gmail
  2. Click on the Streak dropdown to the right of the search bar
  3. Select the Integrations button. This will open a window where you can view existing integrations and create new API keys.
  4. Under the Streak API section of integrations, click the button to Create New Key.

Windows Forms Controls

The code below shows how to populate a DevExpress chart with Streak data. The StreakDataAdapter binds to the Series property of the chart control. The Diagram property of the control defines the x- and y-axes as the column names.

using (StreakConnection connection = new StreakConnection( "ApiKey=8c84j9b4j54762ce809ej6a782d776j3;")) { StreakDataAdapter dataAdapter = new StreakDataAdapter( "SELECT UserKey, Email FROM Users WHERE Email = 'user@domain.com'", connection); DataTable table = new DataTable(); dataAdapter.Fill(table); DevExpress.XtraCharts.Series series = new DevExpress.XtraCharts.Series(); chartControl1.Series.Add(series); series.DataSource = table; series.ValueDataMembers.AddRange(new string[] { "Email" }); series.ArgumentScaleType = DevExpress.XtraCharts.ScaleType.Qualitative; series.ArgumentDataMember = "UserKey"; series.ValueScaleType = DevExpress.XtraCharts.ScaleType.Numerical; chartControl1.Legend.Visibility = DevExpress.Utils.DefaultBoolean.False; ((DevExpress.XtraCharts.SideBySideBarSeriesView)series.View).ColorEach = true; }

Web Controls

The code below shows how to populate a DevExpress Web control with Streak data. The StreakDataAdapter binds to the Series property of the chart; the Diagram property defines the x- and y-axes as the column names.

using DevExpress.XtraCharts; using (StreakConnection connection = new StreakConnection( "ApiKey=8c84j9b4j54762ce809ej6a782d776j3;")) { StreakDataAdapter StreakDataAdapter1 = new StreakDataAdapter("SELECT UserKey, Email FROM Users WHERE Email = 'user@domain.com'", connection); DataTable table = new DataTable(); StreakDataAdapter1.Fill(table); DevExpress.XtraCharts.Series series = new Series("Series1", ViewType.Bar); WebChartControl1.Series.Add(series); series.DataSource = table; series.ValueDataMembers.AddRange(new string[] { "Email" }); series.ArgumentScaleType = ScaleType.Qualitative; series.ArgumentDataMember = "UserKey"; series.ValueScaleType = ScaleType.Numerical; ((DevExpress.XtraCharts.SideBySideBarSeriesView)series.View).ColorEach = true; }
 
 
ダウンロード