Programming databaseconnections?

Hi!

I want some tutorials on how to actually program database applications. Everything seems so bound with the data controls provided by Visual Studio and coming from PHP I don't like to not have full control over my applications. So where can I learn about creating my own database applications without using repeater, gridview or formview?

Thank you in advance!

yes data controls can be over-welming and I see many instances where the pursuit of them consumes more effort that a more procedural approach. Coming from PHO, have you looked at http://www.learn2asp.net/php/Campaign.aspx - these should help your transition to ASP.NET from PHP.

There are also some good tutorials on programming database applications at http://www.asp.net/learn/videos/default.aspx?tabid=63

Programmatically Enabling sa Login in SS2K5?

Hello.

Our software applications require the sa login to be enabled. We have a .NET (C#) installation application that installs our software applications.

So, is there any way that we can programmatically enable the sa login for SQL Server 2005? Ideally, we'd like to code this into our installation application.

Thanks.

The login is enabled by default if you installed with Mixed Authentication.

You can enable it by executing:

ALTER LOGIN sa ENABLE

Thanks
Laurentiu