Jump to content
Software FX Community

Importing data from Oracle Database


Recommended Posts

I am trying to chart data from an Oracle Database using the Oracle Connection String in Visual Studio 2003.

 However, when I attempt to chart the data from the filled dataset, it plots the dataset properties rather than the actual data in the table.

 Here is my code; it's less than professional but it should serve its purpose


Imports System.Data.OleDb
Imports SoftwareFX.ChartFX.Lite
Public Class Form1
  Inherits System.Windows.Forms.Form


  Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
  'Change the connection string to be sure that is pointing to the right please.
  'Users should change at design time too.
  Chart1.SerLegBox = True
  Me.oracleConnection1.ConnectionString = "User Id=xxx.xxxx;Data Source=xxxx-xxxx-ORACLE;Password=xxx;Persist Security Info=true;"

  End Sub


  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  With Chart1
  'Notice that DataType needs to be set bebore filling the dataset or before binding
  .DataType(0) = DataType.Value
  .DataType(1) = DataType.Value

  .DataSource = Me.MvwVolume6Month51.MvwVolume6Month.ASSIGNED_GROUPColumn
  .DataSource = Me.MvwVolume6Month51.MvwVolume6Month.N_TICKETSColumn

  .Gallery = Gallery.Bar
  'It requires: Imports SoftwareFX.ChartFX.Lite

  With .AxisX
  .Gridlines = True

  End With

  End With

  End Sub

End Class

Posted Image



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...