Bagikan melalui


OleDbError.SQLState Properti

Definisi

Mendapatkan kode kesalahan lima karakter setelah standar ANSI SQL untuk database.

public:
 property System::String ^ SQLState { System::String ^ get(); };
public string SQLState { get; }
member this.SQLState : string
Public ReadOnly Property SQLState As String

Nilai Properti

Kode kesalahan lima karakter, yang mengidentifikasi sumber kesalahan, jika kesalahan dapat dikeluarkan dari lebih dari satu tempat.

Contoh

Contoh berikut menampilkan properti dari 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

Berlaku untuk

Lihat juga