For test purpose I did a little test in C#, where I did use ADO.NET to make a connection to my SQL Server.
The common way to access a database is to do the following:
- Open a connection to the Database
- Perform the Query using a recordset for the returned data
- Extract Data needed and close the recordset
- Close the connection
Lets take a close look on how to do it in C# ADO.NET