Which is the best book for existing, experienced 'old-style' ASP coders to quickly translate their thinking process to the new ASPX method? Something with lots of example translations: Here's how you did X in ASP, here's how to do the same thing with best practices of ASPX...

It depends if you are using VB.NET or C#.NET though you aren't limited to just those 2.

Try:
http://www.wrox.com/books/0764543865.shtml
or
http://www.wrox.com/books/0764543776.shtml

Yes, that's a good book, I've got the C# version. :)

My biggest confusion at this time is adapting to how to work with the database objects. I hate adding/editing info with raw SQL statements. Could someone show me how to translate the following ASP code into C#-based ASPX code? I am confused on talking to ODBC, and the syntax on ADO objects. Thanks! :D

    Set dbConn = Server.CreateObject("ADODB.Connection")
    dbConn.Open "DSN=ROTFOH;uid=xxxxxxx;pwd=xxxxxxx"

    Set rsMonster = CreateObject("ADODB.Recordset")
    rsMonster.Open "Monster", dbConn, adOpenStatic, adLockOptimistic

    rsMonster.AddNew

    rsMonster("Descr") = Request.Form("Descr")
    rsMonster("AC") = Request.Form("AC")
    rsMonster("HD") = Request.Form("HD")
    rsMonster("NumAppearing") = Request.Form("NumAppearing")
    rsMonster("DamageH") = Request.Form("DamageH")
    rsMonster("DamageL") = Request.Form("DamageL")
    rsMonster("AttackDesc") = Request.Form("AttackDesc")
    rsMonster("AttPerRound") = Request.Form("AttPerRound")

    rsMonster.Update

    Response.Write("Monster Record Created!<p>")
    Response.Write("<form action=AdminMonsterEditor.asp method=post>")
    Response.Write("<input type=submit value='Monster Editor'>")
    Response.Write("</form>")