Just getting started with ASP.NET

kfinch

22y3.1k.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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

kfinch22y ago
I don't think that email address works. I have a potential project that I'm trying to get and I don't want to do it in ASP. I could do it easily but I need to impress the client with the latest and greatest. I'm just learning ASP.NET and any tips on connecting to SQL Server would be great. Also, writing data to my pages, inserting, updating, and deleting data would help too. If I want to welcome a user on a navigation page by their first name which is 'FName' in the 'EmployeeInfo' table of the '211Tech' database in SQL SERVER what's the best way to accomplish "Welcome Stefan!"? Everything is on one machine for my presentation, iis, SQL Server, and my webAp. If I can see how to build a login to take me to the navigation page and say "Welcome Stefan!" I can figure out the rest of this project on my own.
S_Kiryazov22y ago
As MS guys say, it's all in MSDN But it's not that clear, I now. I clearly remember how I got to ask the same questions. So, write to [email protected] and write you back and attach a little example.