C1 Community

Hellou,
I would like to know if RecordSet can be Datasource to a chart. If so, how could I then set values for X and Y axis?

Thanx for your help.

Dado

Not directly because Recordset objects do not implement the right datasource interface, but with an OleDBDataAdapter you can fill a dataTable with a recordset and simply assign the dataTable to the DataSource property of the chart.

Imports System.Data.OleDB
...
Dim da As New OleDbDataAdapter
Dim dt As New DataTable("Table Name")
da.Fill(dt, yourRecordSet)
C1Chart1.DataSource = dt


And then you set the X and Y dataFields to the column names from your recordset.

C1Chart1.ChartGroups(0).ChartData.SeriesList(0).X.DataField = "col 1"
C1Chart1.ChartGroups(0).ChartData.SeriesList(0).Y.DataField = "col 2"


hope that helps some,
-Greg L

What about C#.

Plus, I don't see those properties in my Properties Window. This is the WebChart for .Net 2.0 correct?



Michael

Hi Michael,
>>What about C#.

using System.Data.OleDB;
...
OleDbDataAdapter da = new OleDbDataAdapter();
DataTable dt = new DataTable();
da.Fill(dt, yourRecordSet);
C1WebChart1.DataSource = dt;
C1WebChart1.ChartGroups[0].ChartData.SeriesList[0].X.DataField = "col 1";
C1WebChart1.ChartGroups[0].ChartData.SeriesList[0].Y.DataField = "col 2";

I am assuming you have a recordset already set up.

 >>Plus, I don't see those properties in my Properties Window. This is the WebChart for .Net 2.0 correct?

There is another forum for WebChart.  The DataSource property can be set in code but not in the designer.

regards,
Greg L