Database Connection Properties: version, data source, WorkstationId, database and etc : Connection « Data Structure « VB.Net

Home
VB.Net
1.2D
2.Application
3.Class
4.Data Structure
5.Data Types
6.Database ADO.net
7.Date Time
8.Development
9.Event
10.File Directory
11.Generics
12.GUI
13.Internationalization I18N
14.Language Basics
15.LINQ
16.Network Remote
17.Reflection
18.Security
19.Thread
20.Windows Presentation Foundation
21.Windows System
22.XML
23.XML LINQ
VB.Net » Data Structure » Connection 




Database Connection Properties: version, data source, WorkstationId, database and etc
Database Connection Properties: version, data source, WorkstationId, database and etc

Imports System
Imports System.Data
Imports System.Data.SqlClient

public class MainClass
   Shared Sub Main()
      Dim connString As String = "server=(local)\SQLEXPRESS; " & _
         "integrated security=sspi;"

      Dim conn As New SqlConnection(connString)

      Try
         conn.Open()
         Console.WriteLine("Connection Opened")

         Console.WriteLine("Connection Properties")
         Console.WriteLine("- ConnectionString : {0}",conn.ConnectionString)
         Console.WriteLine("- Database : {0}",conn.Database)
         Console.WriteLine("- DataSource : {0}", conn.DataSource)
         Console.WriteLine("- ServerVersion : {0}", conn.ServerVersion)
         Console.WriteLine("- State : {0}", conn.State)
         Console.WriteLine("- WorkstationId : {0}", conn.WorkstationId)

      Catch ex As SqlException
         Console.WriteLine("Error: " & ex.ToString())
      Finally
         conn.Close()
         Console.WriteLine("Connection Closed")

      End Try
   End Sub
End Class

           
       














Related examples in the same category
1.Check the state of the connection and report appropriatelyCheck the state of the connection and report appropriately
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.