Data from Microsoft SQL server in Windows 7 Gadget

Bookmark and Share
Data from Microsoft SQL server in Windows 7 Gadget. So I recieved another of the fan mails with the following questions. If you come across similar issues feel free to email me.

1. Is there any sample code to use web service to pull the data from Microsoft SQL server 2005/2008?

The Sitemeter Gadget chapter 9 uses Ajax to pull data from online web service and sitemeter uses database in the background to pull and display data. so as long as your web service is able to pull and display data in the form of TEXT, XML, RSS, ATOM, JSON, HTML and HTML, you can display it in the Gadget.

2. I have an icon/image to refresh the data on the Gadget.. is it possible to change the cursor to wait/ progress till the data gets refreshed?

Search for this functionality in JavaScript in an html page. Gadget main page is essentially an html page and you can inlcude a JavaScript file which can be used to change the cursor.

3. Is it possible to show spinner on clicking the OK button in the settings page?

Yes, we do this in blog gadget(loading animation) chapter 8

4. Is it possible to show some alerts upon clicking the OK button in the settings page?

Most of the widgets, allows for message alert, you should also check debugging section to see how to use JavaScript and VBScript alert boxes, look also the last chapter Tips and Tricks

{ 0 comments... Views All / Send Comment! }

Post a Comment