I feel like an idiot for asking this - but how the heck do I assign a database field to a variable in ASP.net 2.0?? in classic asp i would do this How do i do this in ASP.net 2.0? Thanks.
ohh man, the new data access layer in asp.net 2.0 is gonna flip your lid! You can run/test/build (with Enterprise Manager) all queries inside of VS.NET without ever touching any other DB tools. Essentially, your going to want to create a folder called App_Code in your project root. Then Right Click, add the data access layer, (it should create like a .xss and another file or something) Anyways, when you play aroudn with these, you'll love them, have them read off a web.config connectionstring. then (sorry for the miss-spellings, I'm drunk right now) but then, when you create the queries graphically in this data layer, everything is now intellesense'd for yah! Its unbelievable!