SqlException::ToString Method ()
.NET Framework (current version)
Returns a string that represents the current SqlException object, and includes the client connection ID (for more information, see ClientConnectionId).
Assembly: System.Data (in System.Data.dll)
Implements
_Exception::ToString()The following C# example shows how a connection attempt to a valid server but non-existent database causes a SqlException, which includes the client connection ID:
using System.Data.SqlClient;
using System;
public class A {
public static void Main() {
SqlConnection connection = new SqlConnection();
connection.ConnectionString = "Data Source=a_valid_server;Initial Catalog=Northwinda;Integrated Security=true";
try {
connection.Open();
}
catch (SqlException p) {
Console.WriteLine("{0}", p.ClientConnectionId);
Console.WriteLine("{0}", p.ToString());
}
connection.Close();
}
}
The following Visual Basic sample is functionally equivalent to the previous (C#) sample:
Imports System.Data.SqlClient
Imports System
Module Module1
Sub Main()
Dim connection As New SqlConnection()
connection.ConnectionString = "Data Source=a_valid_server;Initial Catalog=Northwinda;Integrated Security=true"
Try
connection.Open()
Catch p As SqlException
Console.WriteLine("{0}", p.ClientConnectionId)
Console.WriteLine("{0}", p.ToString())
End Try
connection.Close()
End Sub
End Module
.NET Framework
Available since 4.5
Available since 4.5
Show: