SqlError.State SqlError.State SqlError.State SqlError.State Property

Definition

Some error messages can be raised at multiple points in the code for the Database Engine. For example, an 1105 error can be raised for several different conditions. Each specific condition that raises an error assigns a unique state code.

public:
 property System::Byte State { System::Byte get(); };
public byte State { get; }
member this.State : byte
Public ReadOnly Property State As Byte

Property Value

The state code.

Examples

The following example displays each SqlError within the SqlErrorCollection collection.

public void DisplaySqlErrors(SqlException exception)
{
	for (int i = 0; i < exception.Errors.Count; i++)
	{
		Console.WriteLine("Index #" + i + "\n" +
			"Source: " + exception.Errors[i].Source + "\n" +
			"Number: " + exception.Errors[i].Number.ToString() + "\n" +
			"State: " + exception.Errors[i].State.ToString() + "\n" +
			"Class: " + exception.Errors[i].Class.ToString() + "\n" +
			"Server: " + exception.Errors[i].Server + "\n" +
			"Message: " + exception.Errors[i].Message + "\n" +
			"Procedure: " + exception.Errors[i].Procedure + "\n" +
			"LineNumber: " + exception.Errors[i].LineNumber.ToString());
	}
	Console.ReadLine();
}
Public Sub DisplaySqlErrors(ByVal exception As SqlException)
    Dim i As Integer

    For i = 0 To exception.Errors.Count - 1
        Console.WriteLine(("Index #" & i & ControlChars.NewLine & _
            "Source: " & exception.Errors(i).Source & ControlChars.NewLine & _
            "Number: " & exception.Errors(i).Number.ToString() & ControlChars.NewLine & _
            "State: " & exception.Errors(i).State.ToString() & ControlChars.NewLine & _
            "Class: " & exception.Errors(i).Class.ToString() & ControlChars.NewLine & _
            "Server: " & exception.Errors(i).Server & ControlChars.NewLine & _
            "Message: " & exception.Errors(i).Message & ControlChars.NewLine & _
            "Procedure: " & exception.Errors(i).Procedure & ControlChars.NewLine & _
            "LineNumber: " & exception.Errors(i).LineNumber.ToString()))
    Next i
    Console.ReadLine()
End Sub

Remarks

State is only set for errors that are received from the server.

For more information on errors generated by SQL Server, see Understanding Database Engine Errors.

Applies to

See also