OleDbError.SQLState Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets the five-character error code following the ANSI SQL standard for the database.
public:
property System::String ^ SQLState { System::String ^ get(); };
public string SQLState { get; }
member this.SQLState : string
Public ReadOnly Property SQLState As String
Property Value
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.
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();
}
Public Sub DisplayOleDbErrorCollection(ByVal exception As OleDbException)
Dim i As Integer
For i = 0 To exception.Errors.Count - 1
Console.WriteLine("Index #" & i.ToString() & ControlChars.Cr _
& "Message: " & exception.Errors(i).Message & ControlChars.Cr _
& "Native: " & exception.Errors(i).NativeError.ToString() & ControlChars.Cr _
& "Source: " & exception.Errors(i).Source & ControlChars.Cr _
& "SQL: " & exception.Errors(i).SQLState & ControlChars.Cr)
Next i
Console.ReadLine()
End Sub
Applies to
See also
Sodelujte z nami v storitvi GitHub
Vir za to vsebino najdete v storitvi GitHub, kjer lahko tudi ustvarite in pregledate težave in zahtevke za uveljavitev sprememb. Če želite več informacij, glejte naš vodnik za sodelavce.