//Configure connection string  
C1GoogleAnalyticsConnectionStringBuilder builder = new C1GoogleAnalyticsConnectionStringBuilder();  
builder.KeyFile = KeyFile;  
builder.ViewId = ViewId;  

//Fetch data  
C1GoogleAnalyticsConnection conn = new C1GoogleAnalyticsConnection(builder.ConnectionString))

//Define command  
string sql = "SELECT Country, Sessions FROM Traffic WHERE Sessions > 500 AND StartDate = '14DaysAgo' AND EndDate = 'Today'";  

//Fetch data  
using (var con = new C1GoogleAnalyticsConnection(gaConnection))  
{  
   con.Open();  

   //Using C1GoogleAnalyticsDataAdapter  
   C1GoogleAnalyticsDataAdapter gaAdapter = new C1GoogleAnalyticsDataAdapter(con, sql);  
   DataTable dt = new DataTable();  
   gaAdapter.Fill(dt);  

   //Display fetched data  
   foreach (DataRow row in dt.Rows)  
   {  
     Console.WriteLine("{0}\t{1}", row["Country"], row["Sessions"]);  
   }  
}

//Configure Connection string  
string gaConnection = string.Format(@"Key File={0};View Id={1};Use Cache=true; Cache Tolerance=6; Cache Location='C:\temp\gacache.db';", KeyFile, ViewId);  

//Define command  
string sql = "SELECT Country, Sessions FROM Traffic WHERE Sessions > 500 AND StartDate = '14DaysAgo' AND EndDate = 'Today'";  

//Fetch data  
using (var con = new C1GoogleAnalyticsConnection(gaConnection))  
{  
  Console.WriteLine("Start Time " + DateTime.Now);  
  con.Open();  
  var command = con.CreateCommand();  
  command.CommandText = sql;  
  var reader = command.ExecuteReader();  
  while (reader.Read())  
  {  
     Console.WriteLine(String.Format("\t{0} --> \t\t{1}", reader["Country"], reader["Sessions"]));  
  }  
  Console.WriteLine("End Time " + DateTime.Now);  
}

static DataSet ReadOperation()  
{  
  //Define Connection String  
  string gaConnection = string.Format("Key File={0};View Id={1}", KeyFile, ViewId);  

  //Define SQL commands  
  string gsql = "SELECT Country, Sessions, NewUsers, PercentNewSessions, LandingPagePath FROM Traffic WHERE Country = 'United States' OR Country = 'India' OR Country = 'Australia' OR Country = 'Canada' OR Country = 'United Kingdom'AND StartDate = '7DaysAgo' AND EndDate = 'Today'";  
   string psql = "SELECT Medium, Users FROM Traffic WHERE Medium = 'referral' OR Medium = 'organic' OR Medium = 'Click-to-Site' OR Medium = 'prospects' OR Medium = 'CPC' OR Medium = '(none)' AND Country = 'United States' OR Country = 'India' OR Country = 'Australia' OR Country = 'Canada' OR Country = 'United Kingdom'";      
    string csql = "SELECT Country, BounceRate, PageViewsPerSession, AvgSessionDuration FROM Traffic WHERE Country = 'United States' OR Country = 'India' OR Country = 'Australia' OR Country = 'Canada' OR Country = 'United Kingdom'";                   

        //Fetch data  
    using (var con = new C1GoogleAnalyticsConnection(gaConnection))  
    {  
       con.Open();  

       DataSet ds = new DataSet();  

       //Using C1GoogleAnalyticsDataAdapter  
       C1GoogleAnalyticsDataAdapter gaAdapter1 = new C1GoogleAnalyticsDataAdapter(con, gsql);  
       gaAdapter1.Fill(ds, "GridData");  

       C1GoogleAnalyticsDataAdapter gaAdapter2 = new C1GoogleAnalyticsDataAdapter(con, psql);  
       gaAdapter2.Fill(ds, "PieData");  

       C1GoogleAnalyticsDataAdapter gaAdapter3 = new C1GoogleAnalyticsDataAdapter(con, csql);  
       gaAdapter3.Fill(ds, "FlexChartData");  

       return ds;  
     }  
 }

//Binding FlexGrid  
public static void BindFlexGrid(DataSet datasource, C1FlexGrid flexGrid, C1ThemeController themeController)  
{  
   //Binding FlexGrid to Datasource  
   flexGrid.DataSource = datasource.Tables[0];  
      //Apply theme to C1FlexGrid, refer to [link](https://www.grapecity.com/componentone/docs/win/online-themes/QSApplyingBuiltInThemetoApp.html) for details  
   themeController.SetTheme(flexGrid, "Office2016White");  
   //Styling FlexGrid  
   flexGrid.BorderStyle = C1.Win.C1FlexGrid.Util.BaseControls.BorderStyleEnum.None;  
   flexGrid.Rows[0].TextAlign = TextAlignEnum.CenterCenter;  
   flexGrid.Cols[0].Visible = false;  
   flexGrid.Cols[2].Width = 200;  
   flexGrid.Cols[2].Aggregate = AggregateEnum.Sum;  
   flexGrid.Cols[2].Format = "N0";  
   flexGrid.Cols[3].Aggregate = AggregateEnum.Sum;  
   flexGrid.Cols[3].Format = "N0";  
   flexGrid.Cols[4].Width = 150;  
   flexGrid.Cols[4].Aggregate = AggregateEnum.Average;  
   flexGrid.Cols[4].Format = "N2";  
   flexGrid.ExtendLastCol = true;  
   //Grouping FlexGrid  
   flexGrid.GroupDescriptions = new List<C1.Win.C1FlexGrid.GroupDescription>() { new C1.Win.C1FlexGrid.GroupDescription("Country") };  
   flexGrid.HideGroupedColumns = true;  
   for (var i = 1; i < flexGrid.Nodes.Length; i++)  
   {  
       flexGrid.Nodes[i].Collapsed = true;  
   }  
}  

//Binding FlexPie  
public static void BindFlexPie(DataSet datasource, FlexPie flexPie)  
{  
   //Passing data in FlexPie  
   flexPie.DataSource = datasource.Tables[1];  
   //Binding FlexPie's AxisX to 'Value' so values appear in Horizontal axis  
   flexPie.Binding = "Users";  
   flexPie.BindingName = "Medium";  
   flexPie.InnerRadius = 0.5;  
   //Specify what and how to show data values  
   flexPie.DataLabel.Content = "{name} : {p:0}%";  
   //Specify where to position the data labels relative to pie slices  
   flexPie.DataLabel.Position = PieLabelPosition.Radial;  
}  

//Binding FlexCharts  
public static void BindFlexCharts(DataSet datasource, FlexChart chart1, FlexChart chart2, FlexChart chart3)  
{  
   //Binding FlexChart1  
   chart1.Series.Clear();  
   chart1.DataSource = datasource.Tables[2];  
   chart1.ChartType = ChartType.Column;  
   chart1.AxisY.MajorGrid = false;  
   //Adding a Series to chart and binding it (AxisY) to 'BounceRate' field  
   chart1.Series.Add(new C1.Win.Chart.Series  
   {  
       Binding = "BounceRate"  
   });  
   //Binding chart's AxisX to 'Country'  
   chart1.BindingX = "Country";  

   //Binding FlexChart2  
   chart2.Series.Clear();  
   chart2.DataSource = datasource.Tables[2];  
   chart2.ChartType = ChartType.LineSymbols;  
   chart2.AxisY.MajorGrid = false;  
   //Adding a Series to chart and binding it (AxisY) to 'PageViewsPerSession' field  
   chart2.Series.Add(new C1.Win.Chart.Series  
   {  
      Binding = "PageViewsPerSession"  
   });  
   //Binding chart's AxisX to 'Country'  
   chart2.BindingX = "Country";  

   //Binding FlexChart3  
   chart3.Series.Clear();  
   chart3.DataSource = datasource.Tables[2];  
   chart3.ChartType = ChartType.LineSymbols;  
   chart3.AxisY.MajorGrid = false;  
   //Adding a Series to chart and binding it (AxisY) to 'AvgSessionDuration' field  
   chart3.Series.Add(new C1.Win.Chart.Series  
   {  
      Binding = "AvgSessionDuration"  
   });  
   //Binding chart's AxisX to 'Country'  
   chart3.BindingX = "Country";  
}

public static void StylingDashboard(C1DashboardLayout dashboardLayout)  
{  
   DashboardTheme dashboardTheme = dashboardLayout.Styles;  
   dashboardTheme.Common.Padding = new C1.Framework.Thickness(10, 10, 10, 10);  
   dashboardTheme.ItemContainer.BackColor = Color.White;  
   dashboardTheme.ItemContainer.Margins = new C1.Framework.Thickness(10, 10, 10, 10);             
}

private void Form1_Load(object sender, EventArgs e)  
{  
  DataSet ds = ReadOperation();  
  BindFlexGrid(ds, c1FlexGrid1, c1ThemeController1);  
  BindFlexPie(ds, flexPie1);  
  BindFlexCharts(ds, flexChart1, flexChart2, flexChart3);  
  StylingDashboard(c1DashboardLayout1);  

  //Set the titles for dashboard tile  
  c1DashboardLayout1.SetCaption(panel2, "Users/Sessions");  
  c1DashboardLayout1.SetCaption(panel7, "Traffic Sources");  
  c1DashboardLayout1.SetCaption(panel9, "Bounce Rate");  
  c1DashboardLayout1.SetCaption(panel11, "Page Views per Session");  
  c1DashboardLayout1.SetCaption(panel13, "Average Session Duration");  
 }