Steema Central

Code: Select all

        private void Form1_Load(object sender, EventArgs e)
        {
            axTChart1.AddSeries(TeeChart.ESeriesClass.scBar);

            OleDbConnection dbConnection;
            OleDbDataAdapter dbAdapter;

            //Connection string to the Excel spreadsheet. HDR states that the sheet has row headings. 
            string conString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                "Data Source=F:\\Downloads\\ImportExcelSheet_AX_CSharp\\charts.xls;" +
                "Extended Properties='Excel 8.0;HDR=Yes'";

            try
            {
                dbConnection = new OleDbConnection(conString);
                dbConnection.Open();

                dbAdapter = new OleDbDataAdapter("SELECT * FROM [Charts.CSV.$]", dbConnection);
                DataSet ds = new DataSet();
                dbAdapter.Fill(ds, "MyData");
                int i = 0;
                axTChart1.Axis.Bottom.Labels.Clear();
                foreach (DataRow dbRow in ds.Tables["MyData"].Rows)
                {
                    if (dbRow[0].ToString() != "")
                        axTChart1.Series(0).Add(Convert.ToDouble(dbRow[2]), dbRow[1].ToString(), Convert.ToUInt32(TeeChart.EConstants.clTeeColor));
                    axTChart1.Axis.Bottom.Labels.Add(i, dbRow[0].ToString());
                    i++;
                }
                axTChart1.Axis.Bottom.Labels.Angle = 90;
                ds.Dispose();
            }
            catch (OleDbException ex)
            {
                MessageBox.Show(ex.Message);
            }
            catch (InvalidOperationException ex)
            {
                MessageBox.Show(ex.Message);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                //
            }
        }