Settings to a simple access to a SQL database
I am learning ASP.NET and I am interested in developing web applications that read/write on SQL databases.
I am using Windows 2000 service pack 4, Microsoft SQL Server 2000 and Microsoft Visual Studio.NET 2003.
I need to TEST the C# code that access, read, append, etc information from and to a SQL database.
In this early stage, I need to know what is the SIMPLEST and practical way to access a SQL database just for the purpose of LEARNING C# and ASP.NET.
Is it the method âASP.NET to SQL Serverâ ?
What changes should I make in the default machine.config and web.config ?
What settings should I make in a given database through the SQL Server Enterprise Manager ( Users, Roles, etc ) ?
What parameters and how should be set in SqlConnection("server=;database=someSQLdatabase;tr usted_connection=; etc) in the C# code;
Should I make any specific changes in the IIS settings ?
Is there any other places where I should change settings ?
I would be very grateful to whoever helps me on that.