The Series datasource method can also be used
to retrieve data from a JDBC database and automatically add it to
the series.
Example:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection c = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://www.steema.net;DatabaseName=Northwind;SelectMethod=cursor",
"teechart", "teechart");
Statement s = c.createStatement();
ResultSet r = s.executeQuery("SELECT * from [Category Sales for
1997]");
series.getYValues().setDataMember("CategorySales");
series.setLabelMember("CategoryName");
series.setDataSource(r);
s.close();
c.close();