using (SqlConnection conn = new SqlConnection(connectionString)) { SqlDataReader reader = null; try { conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); reader = cmd.ExecuteReader(); //read data } finally { if (reader != null) reader.Close(); conn.Close(); } }
using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader reader = cmd.ExecuteReader(); //read data reader.Close(); conn.Close(); }In both examples, we use the SqlDataReader.Close method to close the SqlDataReader object after reading data from it. The package library for this method is System.Data.SqlClient.