Just getting started with ASP.NET
Okay, I've successfully created a few .aspx pages and I'm beginning to see how things work. Now I want to start connecting to my SQL Server, retreiving, inserting, updating, and deleting records. I'm used to doing things in ASP, and this is all new to me. My typical connection string looked like this:
Set connStr = Server.CreateObject("ADODB.Connection")
connStr.Open "Provider=SQLOLEDB; Data Source=#####;" & _
"Initial Catalog=#####;UId=#####;pwd=#####;"
This doesn't seem to work anymore. Apparently Set is no longer used. Is there a good example(s) somewhere of these previously simple tasks? Any help on these few things would be greatly appreciated.