ASP Tutorials?

[Limpster]

Does anyone know any good ASP tutorials. I have already looked through this site and searched on google. The tutorials I found were just a bit of this an a bit of that. I want something really detailed (Database connections and such) perferably a PDF e-book or something. Thanks in advance

[Maverick811]

Well, I'm still looking for some really detailed tutorials like you are referring to, but I'll throw in some links that have helped me greatly in the past:

Database connection strings (examples): http://www.able-consulting.com/ADO_Conn.htm
Good bit about .ASP: http://www.w3schools.com/asp/default.asp

Hope these are of some use to you...

[Limpster]

Thanks...Ive already taken the w3schools.com one..It helped...The other one is a bit weird...Im looking for something more explanatory (I dont know if thats a word )Thanks anyway though

[Juridian]

http://www.15seconds.com

http://msdn.microsoft.com

http://www.4guysfromrolla.com

If you want database interaction you should be looking up ADO. That is what your asp should be using to interact with databases.

[johnnymier]

Ok, I will give you a few tips on db connection using asp: I used MS sql server 2000

DB connection:

<%
set conect= Server.CreateObject("ADODB.Connection")
lincon= "dsn=testodbc; uid=user; pwd=passwd"
conec.open lincon
%>


Executing queries:

set result= conect.execute ("create, drop, select, update......)


Note: conect, result are just variables, testodbc means I created and named an odbc as "test", user and passwd are just any user name and password for your database.

Hope this helps, I could go more into depth about configuring MS SQL server 2000 for using with asp. Also checkout my turorial about php with a database, in my opinion I prefer php over asp...

[Limpster]

Ok...I got the connection stuff down...I haveing trouble doing things like Putting A table in text boxes then paging through each record one by one using a submit button

[johnnymier]

I don't understand, you want to put info into your tables using a submit button???? Or do you want your info displayed in text boxes????
Could you please be more specific

[angad]

guys whats up? my problem is a bit complex(well thats what i think)
ok.
consider a .asp file on the net.here i have to enter a number (say rollnumber) and then it give me the results related to that number.
e.g- i give some exam QWERTY and my roll number is 12345. so when results for the exam are announced i go to the site and open the corresponding .asp(say result.asp). i enter my nnumber 12345 and press enter. now it will show my name and my score in QWERYTY exam.
here's my question: is there any way i can search for a name (say Sam) and get all other information related to Sam (his score and roll number etc)???
Please help me guys

[Aspman]

You would have been better to start a new thread rather than add to another very old one.

Replying to old threads is a big no no round here and likely to get you some negs.

The flashing date in the other entries shows that the thread is old. If you were adding something significant to the original discussion you'd get away with it. But you're not.

Read the faq and save yourself some grief.

[angad]

THANKS DUDE