OdbcError.SQLState Properti

Definisi

Ruang nama:

System.Data.Odbc

Rakitan:

System.Data.Odbc.dll

Paket:

System.Data.Odbc v9.0.0-preview.6.24327.7

Sumber:

OdbcError.cs

Mendapatkan kode kesalahan lima karakter yang mengikuti 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

String

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

Contoh

Contoh berikut menampilkan properti dari 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();
}

Public Sub DisplayOdbcErrorCollection(ByVal exception As OdbcException)
    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

Lihat juga

• OdbcErrorCollection
• OdbcException