ASP and Databases

Any good tutorials out there?

[katana_one]

Hello, newbie question here.

I know how to build pages in HTML and CSS, but only have limited experience with ASP (simple file includes are about the extent of it). I have no experience at all with databases.

I need to create a database of items and a search utility for my website. Since the server already supports ASP, I want to learn how to build a database and create dynamic pages from that database using ASP. Are there any good tutorials out there anyone can recommend? So far, all the ones I've found online are a bit over my head at this point.

[ogletree]

Dreamweaver makes it real easy.

[mcavill]

it's a bit tricky as most tutorial type sites now seem to concentrate on .net (if your hosts supports .net, it may be worth looking at instead...) anyway, for ASP I've found these quite good:

[w3schools.com...]
[devguru.com...]

[edited by: Xoc at 3:42 am (utc) on Aug. 31, 2004]
[edit reason] made links active [/edit]

[timchuma]

I would also recommend downloading the PDF version of the knowledgebase from [aspfaq.com...] as you can search for things like error codes in it and it will tell you the common errors that lead to them.

Thanks.

[katana_one]

>>Dreamweaver makes it real easy<<

Maybe you've got a different version of DW, or maybe I'm just dense, but I've tried DW and can't get the tutorials to work.

As for w3schools and devguru, I've already been to w3school and regularly refer to it for CSS and HTML. However, the ASP tutorial makes my head hurt. I did not find the devguru pdf file very useful either as it does not tell you how to use the commands defined within it.

The asp faq page would be a great asset in looking up error codes - but since I can't actually write any asp scripts it is of no use to me at the moment.

I just want a simple "how to" on setting up a simple database and retrieving sorted data from it. Is such a thing available?

[mattglet]

I would suggest getting ASP For Beginners by WROX Publishing.

[wackal]

check out [4guysfromrolla.com...]

I basically taught myself ASP using their articles. Don't look at the new stuff, it's mostly all .NET, but the archives have some great articles on pretty much anything you want to do in ASP.

[maxbot]

Try going to [aspin.com...] they are a good starting point. The best way to start learning is to start from the advanced tutorials and get really interested in the subject. Just read articles like "How to send email with ASP" or "how to upload images to a database". Even though you dont understand jack, it will get your craving going. THen go and read basic stuff (this way you will avoid the headaces). Just one more thing, you WILL GET ERRORS, and lots of them. Everybody does, its normal. Just keep trying. if it doesnt work, take a break and think about it during the day what it could be instead of killing yourself 24/7 on the comp and next day try again.

[Easy_Coder]

The MSDN is a great resource for MS Technologies...

Microsoft Office Development Center:
[msdn.microsoft.com...]

MSDN ASP Center:
[msdn.microsoft.com...]

[katana_one]

Hey, thanks for all the suggestions and encouragement everybody.

I finally got the DreamWeaver tutorial working! This is a big help to me as I can now get a live view of the changes to the code as DW writes it. Now I'm getting my hands dirty by making minor edits to DW's code directly in code-view and seeing the changes live.

Thanks again.