Obtain a pooled connection : SqlConnection « Database ADO.net « VB.Net

Home
VB.Net
1.2D
2.Application
3.Class
4.Data Structure
5.Data Types
6.Database ADO.net
7.Development
8.Event
9.File Directory
10.Generics
11.GUI
12.Language Basics
13.LINQ
14.Network Remote
15.Security
16.Thread
17.Windows Presentation Foundation
18.Windows System
19.XML
20.XML LINQ
VB.Net Tutorial
VB.Net by API
VB.Net » Database ADO.net » SqlConnectionScreenshots 
Obtain a pooled connection
  
Imports System
Imports System.Data.SqlClient

    Public Class MainClass
        Public Shared Sub Main()
            Using con As New SqlConnection
                con.ConnectionString = "Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=SSPI;Min Pool Size=5;Max Pool Size=15;Connection Reset=True;Connection Lifetime=600;"
                con.Open()
                con.Close()
            End Using
            Using con As New SqlConnection
                con.ConnectionString = "Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=SSPI;Pooling=False;"
                con.Open()
                con.Close()
            End Using
        End Sub

    End Class

   
    
  
Related examples in the same category
1.Connection state change eventConnection state change event
2.Info Message EventInfo Message Event
3.Display the information about the connection.
4.Execute Non Query Example
5.Parameterized Command Example
6.Parse the SQL Server connection string and display the component configuration parameters.
7.SQL Server Online Check
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.