WPF Toolkit Chart

索引サイト





あちこちに「Chart」があるので、本当に Toolkit だよなあ・・と

xmlns:chartingToolkit="clr-namespace:System.Windows.Controls.DataVisualization.Charting;

assembly=System.Windows.Controls.DataVisualization.Toolkit









<chartingToolkit:Chart Grid.Column="1" Grid.Row="2" Margin="3" Name="tab3_chart1" Title="WPF Chart-1-" >

    <chartingToolkit:LineSeries Name="LineSeries_1" 

                                IndependentValuePath="month" DependentValuePath="cost" 

                                DataContext="{Binding}" ItemsSource="{Binding}"  

                                IsSelectionEnabled="True" Title="Line1" />

    <chartingToolkit:Chart.Axes>

        <chartingToolkit:LinearAxis Orientation="X" Title="年月"/>

        <chartingToolkit:LinearAxis Orientation="Y" Title="金額"/>

    </chartingToolkit:Chart.Axes>

</chartingToolkit:Chart>

ひさびさの七転八倒、七転八起。気難しいのは相変わらず





private void proc_transition_1_chart()

{

    String w_SQL = null;

    w_SQL += "select sum(genka) as cost";

    w_SQL += ",Code as code";

    w_SQL += ",substring(Date,6,2) as month";

    w_SQL += " from tb_srdata";

    w_SQL += " where Date >= '" + this.textBox_Date1.Text + "'";

    w_SQL += " and   Date <= '" + this.textBox_Date2.Text + "'";

    w_SQL += " group by Code,month";

    w_SQL += " order by Code,month";
    z_CMD_YSYS.Connection = z_DB_YSYS;

    z_CMD_YSYS.CommandText = w_SQL;

    System.Data.Odbc.OdbcDataReader w_Reader = z_CMD_YSYS.ExecuteReader();
    DataTable w_dataTable = new System.Data.DataTable();

    w_dataTable.Columns.Add("CD");

    w_dataTable.Columns.Add("month");

    w_dataTable.Columns.Add("cost");

    DataRow w_DataRow;

    while (w_Reader.Read())

    {

        w_DataRow = w_dataTable.Rows.Add();

        w_DataRow["CD"] = Convert.ToString(w_Reader["code"]);

        w_DataRow["month"] = Convert.ToInt16(w_Reader["month"]);

        w_DataRow["cost"] = Convert.ToDouble(w_Reader["cost"]);

    }

    w_Reader.Close();

    this.tab3_dataGrid_chart.ItemsSource = w_dataTable.DefaultView;

    this.tab3_dataGrid_chart.FontSize = 12;

    this.tab3_dataGrid_chart.SelectedIndex = 0;
    MessageBox.Show("wait");

    //エラーで表示されず

    //LineSeries_1.ItemsSource = w_dataTable.DefaultView;

    //***********************************

    //  dataset でテスト

    //***********************************

    System.Data.DataSet w_dsWPF = new System.Data.DataSet();

    System.Data.Odbc.OdbcDataAdapter w_Adapter = new System.Data.Odbc.OdbcDataAdapter(w_SQL, z_DB_YSYS);

    System.Data.DataSet w_dataset = new System.Data.DataSet();

    w_Adapter.Fill(w_dsWPF, "Rset");

    this.tab3_dataGrid_chart.ItemsSource = w_dsWPF.Tables[0].DefaultView;
    //スルーされて表示されず

    //this.tab3_chart1.DataContext = w_dsWPF.Tables[0].DefaultView;

    LineSeries_1.ItemsSource = w_dsWPF.Tables[0].DefaultView;

}

データテーブルについてはテスト継続中




AX