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 6234 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 decode a base64 string in C#?

Here's a sample code snippet demonstrating how you can easily decode a base64 encoded string in C#. ...

How to disable editing of items in a combo box in c#?

When working in Win forms using C# and especially when you use the combo box , you would have notice...

C# Program to swap two numbers without using temporary variable

Problem Write a program in Visual CSharp to swap two numbers using temporary variable and display t...