Gauge and SQL Server using MVVM

5 posts, 1 answers
  1. Alex
    Alex avatar
    3 posts
    Member since:
    May 2008

    Posted 29 Jul 2010 Link to this post

    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
  2. Answer
    Andrey
    Admin
    Andrey avatar
    1681 posts

    Posted 02 Aug 2010 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. DevCraft banner
  4. Alex
    Alex avatar
    3 posts
    Member since:
    May 2008

    Posted 03 Aug 2010 Link to this post

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

    Thanks,
    Alex
  5. Aafaq
    Aafaq  avatar
    2 posts
    Member since:
    Nov 2009

    Posted 03 Nov 2010 Link to this post

    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
  6. Aafaq
    Aafaq  avatar
    2 posts
    Member since:
    Nov 2009

    Posted 03 Nov 2010 Link to this post

    Hi,

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

    Thanks,
    Aafaq
Back to Top
DevCraft banner