Does End Using close an open SQL Connection

by

Exiting a using block calls .Dispose() on the object in question (cn in your example) which for a SqlConnection will close the connection and any open resources.

More Related Contents:

  1. Does this code prevent SQL injection?
  2. Update primary key value using entity framework
  3. Using “GO” within a transaction
  4. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  5. How can you name the Dataset’s Tables you return in a stored proc?
  6. Using a variable for table name in ‘From’ clause in SQL Server 2008
  7. Syntax not valid on word ‘ON’ in SQL join statement [closed]
  8. How do you effectively model inheritance in a database?
  9. How does SQLParameter prevent SQL Injection?
  10. store image in database or in a system file? [closed]
  11. Parse Delimited CSV in .NET
  12. Fastest way to perform nested bulk inserts with scope_identity() usage?
  13. Is the Microsoft.VisualBasic namespace “true .NET” code?
  14. Bulk Insert to Oracle using .NET
  15. SqlDateTime.MinValue != DateTime.MinValue, why?
  16. Code to validate SQL Scripts
  17. SqlConnection.Close() inside using statement
  18. Option Strict On and .NET for VB6 programmers
  19. Cause this VB6-like smell, which VB.NET allows, to error instead: WinFormType.InstanceProp=Value [DISABLE My.Forms]
  20. How to print datagridview table with its header in vb.net?
  21. How to draw a signature and save it to disc as a Bitmap?
  22. Form’s TransparencyKey leaves ghastly colored edging [closed]
  23. Redirect Trace output to Console
  24. How to make a Windows Forms .NET application display as tray icon?
  25. LinqToSql declare and instantiate DataContext best practice?
  26. .NET, the SqlConnection object, and multi-threading
  27. Implementing transactions over multiple databases
  28. Use SQL Server time datatype in C#.NET application?
  29. Is there a way to define an implicit conversion operator in VB.NET?
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment