I am trying to bind a basic chart at runtime as a proof of concept. I have tried everything without any luck. Help! Are there any explicit instructions? Any help would be apprieciated.
Thanks,
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using Telerik.Reporting;
using Telerik.Reporting.Drawing;
using System.Collections;
using Processing = Telerik.Reporting.Processing;
using System.Text;
using System.Data;
using System.Data.OleDb;
using Oracle.DataAccess;
using Oracle.DataAccess.Client;
using System.Configuration;
/// <summary>
/// Summary description for UtilDcpType.
/// </summary>
public partial class UtilDcpType : Telerik.Reporting.Report
{
public UtilDcpType()
{
/// <summary>
/// Required for telerik Reporting designer support
/// </summary>
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
// TODO: This line of code loads data into the 'appDcpDataSet.appDcpDataSetTable' table. You can move, or remove it, as needed.
try
{
//this.appDcpDataSetTableAdapter1.Fill(this.appDcpDataSet.appDcpDataSetTable);
string m_connString = ConfigurationManager.ConnectionStrings["ProdOle"].ConnectionString;
OleDbConnection conn = new OleDbConnection(m_connString);
string selectCommand = @"SELECT * FROM (
SELECT UTIL_DCP_TYPE, COUNT(UTIL_DCP_TYPE) AS cnt
FROM APP_DCP
GROUP BY UTIL_DCP_TYPE) CNT
WHERE CNT.CNT > 1000";
OleDbDataAdapter adapter = new OleDbDataAdapter(selectCommand, conn);
//SqlConnection conn = new SqlConnection(
//@"Server=(local)\SQLEXPRESS;Integrated Security=true;Database=AdventureWorksT");
//string selectCommand = "SELECT * FROM Production.Product";
//SqlDataAdapter adapter = new SqlDataAdapter(selectCommand, conn);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
this.DataSource = dataSet;
this.DataMember = "Table";
}
catch (System.Exception ex)
{
// An error has occurred while filling the data set. Please check the exception for more information.
System.Diagnostics.Debug.WriteLine(ex.Message); }
}
private void chart1_NeedDataSource(object sender, System.EventArgs e)
{
Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart;
string m_connString = ConfigurationManager.ConnectionStrings["Prod"].ConnectionString;
OleDbConnection conn = new OleDbConnection(m_connString);
//OracleConnection conn = new OracleConnection(m_connString);
string cmdText = @"SELECT * FROM (
SELECT UTIL_DCP_TYPE, COUNT(UTIL_DCP_TYPE) AS cnt
FROM APP_DCP
GROUP BY UTIL_DCP_TYPE) CNT
WHERE CNT.CNT > 1000";
OleDbDataAdapter adapter = new OleDbDataAdapter(cmdText, conn);
// OracleDataAdapter adapter = new OracleDataAdapter(cmdText, conn);
DataSet ds = new DataSet();
//adapter.SelectCommand = cmd;
adapter.Fill(ds);
MessageBox.Show("got here!");
DataView view = ds.Tables[0].DefaultView;
view.Sort = "Rank DESC";
chart.DataSource = view;
}
}