SqlException.ToString Method

public:
 override System::String ^ ToString();

public override string ToString();

override this.ToString : unit -> string

Public Overrides Function ToString () As String

Returns

A string that represents the current SqlException object. String.

Examples

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 Microsoft.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 Microsoft.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  

The following 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;
using Microsoft.Data.SqlClient;

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();
    }
}

Imports System
Imports Microsoft.Data.SqlClient

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