Gauge and SQL Server using MVVM

[Alex]

Hi,

Is there a small sample project I can reference that shows how to integrate the gauge controls (radial or linear) with SQL Server using the MVVM design pattern? I have gone over the Task-It MVVM sample project but the one visualization control (a chart) is loading hard-coded data due to an issue with getting Function Import working on the data model.

Any assistance you can provide is greatly appreciated.

Thanks,
Alex

[Andrey]

Hello Alex,

You can bind the "value" field you retrieve from SQL Server to the Value property of your desired gauge indicator.

We have attached a sample application that uses Linq To Sql Classes Template and WCF service to achieve the desired effect. The linq query is commented out and the sample emulates its result (Service1.GetScores method) but you can update the data context (DataClasses1.dbml) to use your actual table and then uncomment and change the query (you will also need to update the service reference).

Greetings,
Andrey Murzov
the Telerik team

[Alex]

Andrey, thank you for your response and sample code - we are now using this approach in our project and works great.

Thanks,
Alex

[Aafaq]

Hi,

  I have a similar issue, I used Linq 2 sql to get my data from the database and used web services to link it to the silverlight project. It works fine on my machine when I debug. But when I publish it on the server it does'nt get any value from the database, infact the webservice fails to respond, I dont get any error message either. Is there a sample project that I can use to query my database with stored procedure and show the results of the query in gridview and gauge in silverlight

Thanks,
Aafaq, Mohammed

[Aafaq]

Hi,

I tried publishing this to the IIS 7.5, It doesnt work. Any suggestions to get this published on the IIS?

Thanks,
Aafaq