Using block for SQLConnection in C#

Published on July 14, 2013 by Senthil Kumar

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 8736 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

C Program to convert lower case string to upper case

Problem Statement Write a program in C to convert the given string from lower case to upper case. ...

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...