wpf simple chart data binding to sql stored procedure

Aug 30, 2010 at 7:57 PM

  

  

  

I'm trying to create a simple bar chart with data coming from a stored procedure on a sql server. This my code for getting the data into a datatable:

**** 

SqlConnection cn = new SqlConnection("Data Source=xxx;Initial Catalog=yyy;User=abcd;Password = 1234")

;

 DataTable dt = new DataTable("Report");

  

 SqlCommand cm = new SqlCommand("dbo.usp_GetData"

, cn);

 

 

cm.Parameters.AddWithValue("@prm1", 1 );  

 

 

cm.CommandType = CommandType .StoredProcedure; 

SqlDataAdapter da = new SqlDataAdapter (cm);

da.Fill(dt);

((ColumnSeries

) CapacityChart.Series[0]).ItemsSource = dt.DefaultView;

****

On the chart itself, I have this as my XAML:

****

 <DVC:Chart x:Name="myChart" Background="AliceBlue" Margin="110,39,26,6" DataContext="{Binding

}">

 

 

<DVC:Chart.Series>

 

<DVC:ColumnSeries Title ="Capacity"

 IndependentValueBinding="{Binding Path=value1}"

 

DependentValueBinding="{Binding Path =value2}" >

 

</DVC:ColumnSeries>

 

</DVC:Chart.Series>

****

I don't get an error message, but I don't get a chart either. What is it that I'm missing? Is there a simple way to bind a dataset or datatable to the chart?