Database Retrieval

[dennic]

Hi

I am creating a website which is database driven, does anyone have any example code where say if a user requests something, it retrieves the data?

any tutorials or could would be appreciated, just the basics to get me started!

[PeOfEo]

I would say buy a book, it is the best way to learn a new technology. I would not be able to tell you any good asp tutorials, but if you are using asp.net I can tell you some of them.

[dennic]

hey

thanks, yeah i bought visual studio.net so anything on asp.net would be appreciated?!

[CardboardHammer]

Use the Help within Visual Studio. It contains all the info you'll need to get started.

[Bullschmidt]

The Samples area of www.asp101.com has some good database examples.

And don't know if this helps at all:

Example URL with a querystring:
http://www.mysite.com/mydir/mypg.asp?myvar1=hey&myvar2=ho

Because a variable might contain some odd characters like spaces, it's usually a good idea to use Server.URLEncode when creating a querystring from a variable:
<a href="http://www.mysite.com/mypage?id=<%= Server.URLEncode(objRS("MyIDFldFromDB")) %>">objRS("MyIDFldFromDB")</a>

And in the page that is opened you can use Request.QueryString("id") to get the value of id.

[PeOfEo]

I would say http://aspnet.4guysfromrolla.com they have great stuff on displaying and using data. As well as a lot of other good stuff.