FAO web + database people

[Jez]

Does anyone know any good resourses (code examples etc) for getting data from an MS SQL database and sticking the results up on a web page using ASP.

E.g. type in a number on a web page, search the DB and return the results in the browser?

I can do SQL and program in VB, its just the transition to asp that I need help with.

Cheers guys
Jez

[Yak]

Here's a couple of sites I use at work when im stuck. The latter is V good.

http://www.sqlcourse.com/

and...

http://www.sloppycode.net/

Or PM me if ya stuck :)

[Yak]

oh this ones dam handy as well :p

http://www.4guysfromrolla.com/

[yeager]

The above sites are what I would also suggest, however one good bit of advice is to use ADO recordsets and not try to construct your own SQL and run that, it's neater and you end up writing more better code.

Simon

[Jez]

Cheers guys - I only need to do a simple demo so those should be fine :)

Just had to battle with my machine to get IIS installed - all woring now though.

[sroberts]

Jez I'll PM you details.

Simon
:)

[Yak]

Oohh I've PMed you some stuff too!

Loads'a info for ya :p :D

[sroberts]

Yak just the man, I think I've got an are which needs doing, i'll send details tomorrow if you want, so you can start having a look at it... nice Signature it looks like mine!

Simon:)

[Yak]

He He He,

Guess where I got the idea / nicked it from :p

I forgot that styles would work on here. Im to used to doing Interactive TV stuff where all you get to use is HTML 3.2 and JS 1.1 :rolleyes: Retro! :D

Cool PM me the info and I'll start a thinking...