> 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?

>  3.how do i connect my gadget to the database?

>  4.How to call a webservice from javascript ?as i could find no other
> option!

> On Sat, Oct 11, 2008 at 8:46 PM, lakshmi <sana.pr...@gmail.com> 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)

> On Oct 12, 7:27 pm, Teo <teomina...@gmail.com> wrote:

> > Hi,
> > i'll answer your questions inline:

> > On Sat, Oct 11, 2008 at 8:46 PM, lakshmi <sana.pr...@gmail.com> 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)