OdbcError.SQLState Property

 

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

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

public string SQLState { get; }

Property Value

Type: System.String

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

The following example displays the properties of the OdbcError.

public void DisplayOdbcErrorCollection(OdbcException 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();
}

.NET Framework
Available since 1.1
Return to top
Show: