Pull down and add

[Michael]

I know how to enter data to a SQL database from a form.

I am making a form where the user inputs some numbers.

Than other users login to this other place and I want the
number that the person imputed to be shown in a field
multipled at a certain price. I am unsure how to pull the
numbers down to display them and do the multiplcation.
The multiplication will show up in another place on the
page.

Does this make sense?

[Ray at]

Do you know how to do a SELECT query to get your number out of the database?
If so, then it's just a matter of some arithmetic operations.

Ray at work

"Michael" <michael@nospam.com> wrote in message
news:07c201c36e4a$2602f870$a001280a@phx.gbl...

> I know how to enter data to a SQL database from a form.
>
> I am making a form where the user inputs some numbers.
>
> Than other users login to this other place and I want the
> number that the person imputed to be shown in a field
> multipled at a certain price. I am unsure how to pull the
> numbers down to display them and do the multiplcation.
> The multiplication will show up in another place on the
> page.
>
> Does this make sense?
>
>

[Mike Moore [MSFT]]

Hi Michael,

I agree with Ray. Also, perhaps these articles will help you. Basically,
you need to do a select statement to retreive the previous user's number
from the database. Then perform multiplication and assign the results to
the text property of a text box. Then it will be displayed.

301216 HOW TO: Populate a DataSet Object from a Database by Using Visual
Basic
[url]http://support.microsoft.com/?id=301216[/url]

301075 HOW TO: Connect to a Database and Run a Command by Using ADO.NET and
[url]http://support.microsoft.com/?id=301075[/url]

Does this answer your question?

Thank you, Mike Moore
Microsoft, ASP.NET

This posting is provided "AS IS", with no warranties, and confers no rights.


--------------------

> Content-Class: urn:content-classes:message
> From: "Michael" <michael@nospam.com>
> Sender: "Michael" <michael@nospam.com>
> Subject: Pull down and add
> Date: Fri, 29 Aug 2003 09:25:24 -0700
> Lines: 14
> Message-ID: <07c201c36e4a$2602f870$a001280a@phx.gbl>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Thread-Index: AcNuSiYCD0mbxJJNSXuOzrJJqUY2nA==
> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
> Newsgroups: microsoft.public.inetserver.asp.general
> Path: cpmsftngxa06.phx.gbl
> Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.asp.general:251074
> NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
> X-Tomcat-NG: microsoft.public.inetserver.asp.general
>
> I know how to enter data to a SQL database from a form.
>
> I am making a form where the user inputs some numbers.
>
> Than other users login to this other place and I want the
> number that the person imputed to be shown in a field
> multipled at a certain price. I am unsure how to pull the
> numbers down to display them and do the multiplcation.
> The multiplication will show up in another place on the
> page.
>
> Does this make sense?
>
>
>