Saturday, December 12, 2009
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.
- Is there any sample code to use web service to pull the data from Microsoft SQL server 2005/2008?
- 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?
- Is it possible to show spinner on clicking the OK button in the settings page?
- Is it possible to show some alerts upon clicking the OK button in the settings page?
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.
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.
Yes, we do this in blog gadget(loading animation) chapter 8
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
Labels: Book, gadgets, user query, windows 7
