Using block for SQLConnection in C#

Published on July 14, 2013 by abundantcode

Filed under C#

Last modified July 14, 2013

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 4317 times

The using statement in C# can also be used to ensure that the resources are automatically cleaned before the using block exits.

One of the criteria of the Using statement is that the items being created in the using statement must implement IDisposable interface.

For example, you can use the using block to open the SQL Connection, retrieve the data.

Using block for SQLConnection in C#

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

namespace AbundantCode


internal class Program


//Using block for SQLConnection in C#

private static void Main(string[] args)


// var AbundantCodeVersions = new string[] { "AbundantCode v1", "AbundantCode v3", "AbundantCode v3", };

using (var conn = new SqlConnection(AbundantCode.GetConnectionString()))








Leave a Comment


You might be Interested in these Posts

How to download a file from a URL using C#?

You can use the WebClient class in C# to download a file. How to download a file from a URL using C...

How to Create an Empty array without defining the size in C# ?

When we create an array in C# , we tend to define the size of the array as shown below. String[] st...

Angular 2 - Video Tutorials and learning materials for Angular 2

Do you want to learn and build web and mobile apps using Angular 2 ?. You can find the list of tutor...