Steema Central

Code: Select all

        private void Form1_Load(object sender, EventArgs e)
        {
          string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/temp/teeChartDemo/teeChartDemo/dataset2.xls;" + "Extended Properties='Excel 8.0'";
            DataSet ds = new DataSet();
            OleDbDataAdapter oada = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
            oada.Fill(ds);

            Contour contour1 = new Steema.TeeChart.Styles.Contour();
            tChart1.Series.Add(contour1);

            contour1.DataSource = ds.Tables[0];
            contour1.XValues.DataMember = "X";//SPEED";
            contour1.YValues.DataMember = "Y";//BMEP";
            contour1.ZValues.DataMember = "Z";//P";

            tChart1.Aspect.View3D = false;
        }