I cant retrieve Information from database

[Shirley]

Hi I have a Silverlight Project. In a Project I have a connection to database by ADO.NET, in the other project i need to do a query to the database, but i cant get information:

using

 

 

PowerIndicadores.Web;

namespace

 

 

PowerIndicadores

{

 

public partial class MainPage : UserControl

{

 

public MainPage()

{

InitializeComponent();

 

//needed for the 3D zoom & interactivity out-of-the-box

chart1.DefaultView.ChartArea.Extensions.Add(

 

new CameraExtension());

chart2.DefaultView.ChartArea.Extensions.Add(

 

new CameraExtension());

chart3.DefaultView.ChartArea.Extensions.Add(

 

new CameraExtension());

 

fopsDomainContext dbContext = new fopsDomainContext();

 

var query = (from p in dbContext.temp_kpi_prod_leadtimeregistrostemas select p.nmbre_lnea_inv);

 

 

 

 

Thanks a lot.

Shirley

 

 

[Evgenia]

Hi Shirley,

You can retrieve data from database using a technology of your choice (like Ado.NET, Linq to SQL, Entity Framework, etc.) and store this data in objects. Then you can bind your RadChart to the collection of these objects and set the SeriesMapping accordingly. Here you may find helpful information how to populate RadControls with data. You may also take a look at our RadChart documentation where we demonstrated how to bind RadChart to Northwind sample database using WCF service or ADO.NET Data Service. There are also online examples with source code provided of RadChart databound to an SQL datasource.
Please note that consuming data from SQL database is beyond the support scope of our RadChart control.
 
If you have some concrete question regarding one of our controls , do let us know and we'll be glad to help.

Regards,
Evgenia
the Telerik team