Re: Google Gadget

Tech-Archive recommends: Fix windows errors by optimizing your registry

bagega wrote:
Hi,
I would to load a set of values stored in a table in MSSQL, and take
the into a google desktop gadget.

I asked for that in GD group and they kindly told me that you're going
to help me.

This is what I have to do:

let's suppose:

Goal: load the values in a table and store them in some variables

DBMS: SQLServer2005
name of the Server "MYSERVER"
name of the table HELPME
name of columns of inteerest ONE and TWO

name of the variables I want to fill var1 and var2

We're going to need some more information:
1. What version of sql server are you using?
2. What programming language and platform are you using
3. Where specifically do you need help?

- With the database tasks? Frankly, the names of your table and columns
don't inspire confidence in your database abilities. If so, what datatypes
are needed for those two columns? Why aren't there any other columns to help
us key the table rows and select which row of data to retrieve from the
table? And why do the table and columns need to have such nondescriptive
names? Are you having trouble creating the table? If so, you should
1. start reading SQL Books Online
2. ask for help with this part in a sqlserver group (although, given some
details, we can provide some help in this area)

- With writing the query to retrieve the data you want?
- With the ADO code to open a connection to the database and open a
recordset?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Caching (?) problem with System.Web.UI.WebControls.Table ???
    ... It seems from the information you provided that you ARE prompting the ... database one on page load to retrieve the data. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: OpenSchema order
    ... I am trying to load info of the columns from various database tables. ... Set objRS = objConn.OpenSchema(adSchemaColumns, ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Faster way to get record sets
    ... your database, etc. ... I still have to question why you are opening all these recordsets. ... retrieve every single field in every one of those tables. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Cant load/retrieve a picture from the database
    ... I have made my webform which is used to load and retrieve the picture from ... the database. ... But when I run it in another machine, it fail to save/retrieve the picture. ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: I cant see my Form
    ... I'm loading a form who connect to my database and ... > retrieve all the information from a table, then I show a progress bar ... > that show de progress of the load job, but the problem is that I ...
    (microsoft.public.vb.general.discussion)