snippet to retrieve data while connected to SQL Server. Uses the SqlDataReader object.

SQLServerWithDataReader.cs

using System.Data.SqlClient;
 
//Step 1: Handshake with the database
SqlConnection myConnection = new SqlConnection(connection string);
 
myConnection.Open();
 
//Step2: Specify the command
 
SqlCommand myCommand = myConnection.CreateCommand();
 
myCommand.CommandText = "T-SQL Here";
myCommand.CommandType = System.Data.CommandType.Text;
 
//Step2.1 Specify stored procedure
myCommand.CommandText = "NameOfStoredProcedure";
myCommand.CommandType = System.Data.CommandType.StoredProcedure;
 
SqlDataReader myDataReader;
 
myDataReader = myCommand.ExecuteReader();
 
//Step 3: Use the data
 
while (myDataReader.Read())
{
//Do something with the data here
}
 
myConnection.Close(); //don't forget to close the connection !!!