hi,
i would like to build an online database to store a list of my shop's items
inventory. anybody can guide me how to do it? or provide some good reference
website where i can learn from ?
thanks

Re: online inventory database by jcochran

jcochran
Fri Nov 07 09:25:55 CST 2003

On Fri, 7 Nov 2003 21:21:39 +0800, "Lynn" <MarryLynn@yah00.c0m> wrote:

>i would like to build an online database to store a list of my shop's items
>inventory. anybody can guide me how to do it? or provide some good reference
>website where i can learn from ?

What base are you starting from in learning? Do you want a pre-done
program or are you writing this yourself from scratch?

Best basic info might be found by Googling "ASP Database Tutorial"
For pre-done scripts, try a search at aspin.com.

Jeff

Re: online inventory database by Lynn

Lynn
Fri Nov 07 09:35:01 CST 2003

frankly speaking i do not know where to start... its my first try on this
project...
should i use asp or asp .net ???

"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:3fb8b900.832255820@msnews.microsoft.com...
> On Fri, 7 Nov 2003 21:21:39 +0800, "Lynn" <MarryLynn@yah00.c0m> wrote:
>
> >i would like to build an online database to store a list of my shop's
items
> >inventory. anybody can guide me how to do it? or provide some good
reference
> >website where i can learn from ?
>
> What base are you starting from in learning? Do you want a pre-done
> program or are you writing this yourself from scratch?
>
> Best basic info might be found by Googling "ASP Database Tutorial"
> For pre-done scripts, try a search at aspin.com.
>
> Jeff



Re: online inventory database by Ping

Ping
Fri Nov 07 14:12:39 CST 2003

Look at http://www.asp.net/Default.aspx for some sample sites builded with
asp.net

greetings,
Andre

"Lynn" <MarryLynn@yah00.c0m> schreef in bericht
news:eG2XCHTpDHA.392@TK2MSFTNGP11.phx.gbl...
> hi,
> i would like to build an online database to store a list of my shop's
items
> inventory. anybody can guide me how to do it? or provide some good
reference
> website where i can learn from ?
> thanks
>
>



Re: online inventory database by jcochran

jcochran
Fri Nov 07 15:24:46 CST 2003

On Fri, 7 Nov 2003 23:35:01 +0800, "Lynn" <MarryLynn@yah00.c0m> wrote:

>frankly speaking i do not know where to start... its my first try on this
>project...
>should i use asp or asp .net ???

Wrong starting point. If you don't know where to start, asking what
tool to use isn't the best first move. You could use either. Or
neither. You start a project by doing some basic research and
creating a project scope.

Let's find out some of your skills first:

Do you know database design, administration and programming? If so,
which database, Access, SQL or other?

Do you know VBScript or C##? If not, do you know any programming
languages?

What types of programs have you written, if any?

What have you done to analyze the project, what budget do you have and
what timeframe do you need to complete it in?

Who will be using the program?

Also, did you look at the references I gave in the first response?
There are plenty of canned scripts and products to do what you want,
and plenty of examples to go by, but which to use depends on what you
know now and what you expect to accomplish.

Jeff


>"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
>news:3fb8b900.832255820@msnews.microsoft.com...
>> On Fri, 7 Nov 2003 21:21:39 +0800, "Lynn" <MarryLynn@yah00.c0m> wrote:
>>
>> >i would like to build an online database to store a list of my shop's
>items
>> >inventory. anybody can guide me how to do it? or provide some good
>reference
>> >website where i can learn from ?
>>
>> What base are you starting from in learning? Do you want a pre-done
>> program or are you writing this yourself from scratch?
>>
>> Best basic info might be found by Googling "ASP Database Tutorial"
>> For pre-done scripts, try a search at aspin.com.
>>
>> Jeff
>


Re: online inventory database by Lynn

Lynn
Fri Nov 07 19:09:30 CST 2003

pls see my ans below

"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:3fae0bf6.853493699@msnews.microsoft.com...
> On Fri, 7 Nov 2003 23:35:01 +0800, "Lynn" <MarryLynn@yah00.c0m> wrote:
>
> >frankly speaking i do not know where to start... its my first try on this
> >project...
> >should i use asp or asp .net ???
>
> Wrong starting point. If you don't know where to start, asking what
> tool to use isn't the best first move. You could use either. Or
> neither. You start a project by doing some basic research and
> creating a project scope.
>
> Let's find out some of your skills first:
>
> Do you know database design, administration and programming? If so,
> which database, Access, SQL or other?
i need to use SQL server db

> Do you know VBScript or C##? If not, do you know any programming
> languages?
VBscript

> What types of programs have you written, if any?
logon scripts

> What have you done to analyze the project, what budget do you have and
> what timeframe do you need to complete it in?
no timeframe
> Who will be using the program?
intranet users

> Also, did you look at the references I gave in the first response?
> There are plenty of canned scripts and products to do what you want,
> and plenty of examples to go by, but which to use depends on what you
> know now and what you expect to accomplish.
>
> Jeff
>
>
> >"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
> >news:3fb8b900.832255820@msnews.microsoft.com...
> >> On Fri, 7 Nov 2003 21:21:39 +0800, "Lynn" <MarryLynn@yah00.c0m> wrote:
> >>
> >> >i would like to build an online database to store a list of my shop's
> >items
> >> >inventory. anybody can guide me how to do it? or provide some good
> >reference
> >> >website where i can learn from ?
> >>
> >> What base are you starting from in learning? Do you want a pre-done
> >> program or are you writing this yourself from scratch?
> >>
> >> Best basic info might be found by Googling "ASP Database Tutorial"
> >> For pre-done scripts, try a search at aspin.com.
> >>
> >> Jeff
> >
>



Re: online inventory database by jcochran

jcochran
Mon Nov 10 09:20:36 CST 2003

>> Do you know database design, administration and programming? If so,
>> which database, Access, SQL or other?
>i need to use SQL server db

But do you know SQL query syntax? If not, you'll need to learn. Try
sqlcourse.com and the SQL newsgroups.

>> Do you know VBScript or C##? If not, do you know any programming
>> languages?
>VBscript

Then you're most likely going to be most comfortable with ASP.
ASP.NET is always an option, but you'll have a learning curve.

Try the ASP groups for help and pointers to basic tutorials.

>> Who will be using the program?
>intranet users

Then you'll need to decide on how you'll connect to SQL, and whether
you'll be authenticating users. This partly is SQL, partly IIS. See:

http://www.iisfaq.com/default.aspx?View=P78&P=145

>> Also, did you look at the references I gave in the first response?
>> There are plenty of canned scripts and products to do what you want,
>> and plenty of examples to go by, but which to use depends on what you
>> know now and what you expect to accomplish.

Go to aspin.com and do some searching. Download samples and look at
them. Google "ASP Database Tutorial" and work your way through some
simple scripting. Once you're comfortable on the basics, design your
program and start coding.

Jeff

Re: online inventory database by Lynn

Lynn
Mon Nov 10 09:43:11 CST 2003

thanks for the guidance. Btw, is php easier to learn compared to asp ?

"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:3fb0ab93.1090963071@msnews.microsoft.com...
> >> Do you know database design, administration and programming? If so,
> >> which database, Access, SQL or other?
> >i need to use SQL server db
>
> But do you know SQL query syntax? If not, you'll need to learn. Try
> sqlcourse.com and the SQL newsgroups.
>
> >> Do you know VBScript or C##? If not, do you know any programming
> >> languages?
> >VBscript
>
> Then you're most likely going to be most comfortable with ASP.
> ASP.NET is always an option, but you'll have a learning curve.
>
> Try the ASP groups for help and pointers to basic tutorials.
>
> >> Who will be using the program?
> >intranet users
>
> Then you'll need to decide on how you'll connect to SQL, and whether
> you'll be authenticating users. This partly is SQL, partly IIS. See:
>
> http://www.iisfaq.com/default.aspx?View=P78&P=145
>
> >> Also, did you look at the references I gave in the first response?
> >> There are plenty of canned scripts and products to do what you want,
> >> and plenty of examples to go by, but which to use depends on what you
> >> know now and what you expect to accomplish.
>
> Go to aspin.com and do some searching. Download samples and look at
> them. Google "ASP Database Tutorial" and work your way through some
> simple scripting. Once you're comfortable on the basics, design your
> program and start coding.
>
> Jeff



Re: online inventory database by Tom

Tom
Mon Nov 10 10:48:42 CST 2003

"Lynn" <MarryLynn@yah00.c0m> wrote in message
news:ukXdLE6pDHA.2584@TK2MSFTNGP09.phx.gbl...
> thanks for the guidance. Btw, is php easier to learn compared to asp ?

It's all relative. (Did you mean VBScript instead of ASP? they're not the
same thing)
If you already know Visual Basic, then no it won't be easier.
If you already know PERL, it might be easier.

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/




Re: online inventory database by jcochran

jcochran
Mon Nov 10 15:03:19 CST 2003

On Mon, 10 Nov 2003 23:43:11 +0800, "Lynn" <MarryLynn@yah00.c0m>
wrote:

>thanks for the guidance. Btw, is php easier to learn compared to asp ?

PHP is a programming language, ASP is not. You said you'd used
VBScript, which works fine for ASP (The other standard is JScript).
If you'd rather use PHP, Python or Perl, feel free. Though you'd be
better off using Apache instead of IIS for some of those.

Besides, your question has no answer that means anything. Easier for
me might mean harder for you. If it makes a difference, I learned
VBScript very quickly, but I had a VB background. PHP was harder when
I learned it because I didn't have as much to go on. C was a bear
because I couldn't remember where the danged semi-colon was required,
and the IDE I used was poor at flagging errors. By the time I started
C## I had no issues with syntax, but I still have a hard time dealing
with class inheritance.

Take some time to sit back and learn a "Hello World!" program in each
language. Then create a database connection and display records from
it. Then insert new records, and change others. When you can do that
in each language, then sit back and draw out your relationships
between data on paper. Then come up with pseudocode for the major
portions of your program, and then decide what language to write in.

And take the discussion to a programming group, you've wandered way
off the topic of IIS here.

Jeff


>"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
>news:3fb0ab93.1090963071@msnews.microsoft.com...
>> >> Do you know database design, administration and programming? If so,
>> >> which database, Access, SQL or other?
>> >i need to use SQL server db
>>
>> But do you know SQL query syntax? If not, you'll need to learn. Try
>> sqlcourse.com and the SQL newsgroups.
>>
>> >> Do you know VBScript or C##? If not, do you know any programming
>> >> languages?
>> >VBscript
>>
>> Then you're most likely going to be most comfortable with ASP.
>> ASP.NET is always an option, but you'll have a learning curve.
>>
>> Try the ASP groups for help and pointers to basic tutorials.
>>
>> >> Who will be using the program?
>> >intranet users
>>
>> Then you'll need to decide on how you'll connect to SQL, and whether
>> you'll be authenticating users. This partly is SQL, partly IIS. See:
>>
>> http://www.iisfaq.com/default.aspx?View=P78&P=145
>>
>> >> Also, did you look at the references I gave in the first response?
>> >> There are plenty of canned scripts and products to do what you want,
>> >> and plenty of examples to go by, but which to use depends on what you
>> >> know now and what you expect to accomplish.
>>
>> Go to aspin.com and do some searching. Download samples and look at
>> them. Google "ASP Database Tutorial" and work your way through some
>> simple scripting. Once you're comfortable on the basics, design your
>> program and start coding.
>>
>> Jeff
>