Using Statement Example OR Uses of Using Statement in C#

Using Statement Example OR Uses of Using Statement in C#
 
If we use using statement in our applications it will automatically create try / finally blocks for the objects and automatically runs Dispose() method for us no need to create any try/finally block and no need to run any Dispose() method.

C#
 

using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand (commandString, con)) { con.Open(); cmd.ExecuteNonQuery(); } }

VB

Using con As New SqlConnection(connectionString) Using cmd As New SqlCommand(commandString, con) con.Open() cmd.ExecuteNonQuery() End Using End Using