I wrote a post putting all this information together (in portuguese) with a sample of inserting adn reading data from sqlite. http://www.athanazio.com/2008/10/13/sqlite-no-google-gadget/
cheers HAL On Oct 13, 12:02 pm, lakki <[EMAIL PROTECTED]> wrote: > Hey thanks a lot.. > > On Oct 12, 7:27 pm, Teo <[EMAIL PROTECTED]> wrote: > > > Hi, > > i'll answer your questions inline: > > > On Sat, Oct 11, 2008 at 8:46 PM, lakshmi <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > This is the first time i am trying to develop a gadget using > > > googlegadget APIs. > > > I have to create a gadget which takes some data from the user and > > > insert that into the local SQl server 2005 database.I Have so many > > > doubts! > > > 1. is there anyAPI which supports SQL conections? > > > No, not really, but you can use a local SQLite database in a pretty > > organized way. Here's a > > tip<http://googledesktopapis.blogspot.com/2008/07/tip-embed-sqlite3-datab...>about > > that. But from what i can tell you don't need it to be local. (please > > read on) > > > 2.can we, by any chance include any other file (except, .js or .XML > > > > files)in the project. > > > Yes. The simpler gadgets usually have a main.xml which defines the interface > > and a main.js. You can have as many .js files you want (within reason :). Be > > careful though, all these answers apply only to Google Desktop gadgets, not > > to iGoogle gadgets; just mentioned to be sure there isn't any confusion.. > > > > 3.how do i connect my gadget to the database? > > > I wrote an article about this, it's about to go live, but until then > > here<http://teodorfilimon.com/articles/Gadget-Usage-Stats/Gadget-Usage-Sta...>'s > > an unpublished version. > > > > 4.How to call a webservice from javascript ?as i could find no other > > > option! > > > You can do this through the XMLHttpRequest object. This > > article<http://code.google.com/apis/desktop/articles/e9.html>should > > help. Javascript is basically the recommended way of programming a > > Google Desktop gadget. The API is growing pretty much lately and it has a > > variety of functions. You can check out the API > > reference<http://code.google.com/apis/desktop/docs/gadget_apiref.html> > > . > > > I hope this helps, > > Teo > > > -- > > Teo (a.k.a. Teominator a.k.a. Teodor Filimon) > > Site -www.teodorfilimon.com|Blog -www.teodorfilimon.blogspot.com > > GMT +2 (or PDT +10) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Desktop Developer Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Google-Desktop-Developer?hl=en -~----------~----~----~----~------~----~------~--~---
