OleDbError.SQLState Property

Definition

Namespace:

System.Data.OleDb

Assembly:

System.Data.OleDb.dll

Package:

System.Data.OleDb v10.0.0-preview.1.25080.5

Source:

OleDbError.cs

Gets the five-character error code following the ANSI SQL standard for the database.

C#

public string SQLState { get; }

Property Value

String

The five-character error code, which identifies the source of the error, if the error can be issued from more than one place.

Examples

The following example displays the properties of the OleDbError.

C#

public void DisplayOleDbErrorCollection(OleDbException exception)
{
    for (int i = 0; i < exception.Errors.Count; i++)
    {
        Console.WriteLine("Index #" + i + "\n" +
            "Message: " + exception.Errors[i].Message + "\n" +
            "Native: " + exception.Errors[i].NativeError.ToString() + "\n" +
            "Source: " + exception.Errors[i].Source + "\n" +
            "SQL: " + exception.Errors[i].SQLState + "\n");
    }
    Console.ReadLine();
}

Applies to

See also

• OleDbErrorCollection
• OleDbException