SqlConnection.FireInfoMessageEventOnUserErrors Property (System.Data.SqlClient)

FireInfoMessageEventOnUserErrors Pr...

Switch on low bandwidth view

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

.NET Framework Class Library

SqlConnection..::.FireInfoMessageEventOnUserErrors Property

Gets or sets the FireInfoMessageEventOnUserErrors property.

Namespace: System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)

Syntax

Visual Basic (Declaration)

Public Property FireInfoMessageEventOnUserErrors As Boolean

Visual Basic (Usage)

Dim instance As SqlConnection
Dim value As Boolean

value = instance.FireInfoMessageEventOnUserErrors

instance.FireInfoMessageEventOnUserErrors = value

public bool FireInfoMessageEventOnUserErrors { get; set; }

Visual C++

public:
property bool FireInfoMessageEventOnUserErrors {
    bool get ();
    void set (bool value);
}

JScript

public function get FireInfoMessageEventOnUserErrors () : boolean
public function set FireInfoMessageEventOnUserErrors (value : boolean)

Property Value

Type: System..::.Boolean
true if the FireInfoMessageEventOnUserErrors property has been set; otherwise false.

Remarks

When you set FireInfoMessageEventOnUserErrors to true, errors that were previously treated as exceptions are now handled as InfoMessage events. All events fire immediately and are handled by the event handler. If is FireInfoMessageEventOnUserErrors is set to false, then InfoMessage events are handled at the end of the procedure.

Note:
An error with a severity level of 17 or above that causes the server to stop processing the command needs to be handled as an exception. In this case, an exception is thrown regardless of how the error is handled in the InfoMessage event.

For more information on working with events, see Connection Events (ADO.NET). For more information on errors generated by the SQL Server engine, see SQL Server Books Online.

Platforms

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Version Information

.NET Framework

Supported in: 3.5, 3.0, 2.0

Reference

SqlConnection Class

SqlConnection Members

System.Data.SqlClient Namespace

Other Resources

Connection Events (ADO.NET)

Connecting to a Data Source (ADO.NET)