Bagikan melalui

SqlDataReader.IsDBNull(Int32) Metode

  • Referensi

Definisi

Ruang nama:
System.Data.SqlClient
Rakitan:
System.Data.SqlClient.dll
Rakitan:
System.Data.dll
Rakitan:
netstandard.dll, System.Data.SqlClient.dll
Paket:
System.Data.SqlClient v4.8.6

Mendapatkan nilai yang menunjukkan apakah kolom berisi nilai yang tidak ada atau hilang.

public:
 override bool IsDBNull(int i);
public:
 virtual bool IsDBNull(int i);
public override bool IsDBNull (int i);
public bool IsDBNull (int i);
override this.IsDBNull : int -> bool
abstract member IsDBNull : int -> bool
override this.IsDBNull : int -> bool
Public Overrides Function IsDBNull (i As Integer) As Boolean
Public Function IsDBNull (i As Integer) As Boolean

Parameter

i
Int32

Ordinal kolom berbasis nol.

Mengembalikan

Boolean

true jika nilai kolom yang ditentukan setara dengan DBNull; jika tidak false.

Penerapan

IsDBNull(Int32)

Keterangan

Panggil metode ini untuk memeriksa nilai kolom null sebelum memanggil metode get yang ditik (misalnya, GetByte, GetChar, dan sebagainya) untuk menghindari menimbulkan kesalahan.

using System;
using System.Data;
using System.Data.SqlClient;

class Program {
   static void Main(string[] args) {

      using (var connection = new SqlConnection(@"Data Source=(local);Initial Catalog=AdventureWorks2012;Integrated Security=SSPI")) {
         var command = new SqlCommand("SELECT p.FirstName, p.MiddleName, p.LastName FROM HumanResources.Employee AS e" +
                                 " JOIN Person.Person AS p ON e.BusinessEntityID = p.BusinessEntityID;", connection);
         connection.Open();
         var reader = command.ExecuteReader();
         while (reader.Read()) {
            Console.Write(reader.GetString(reader.GetOrdinal("FirstName")));
            // display middle name only of not null
            if (!reader.IsDBNull(reader.GetOrdinal("MiddleName")))
               Console.Write(" {0}", reader.GetString(reader.GetOrdinal("MiddleName")));
            Console.WriteLine(" {0}", reader.GetString(reader.GetOrdinal("LastName")));
         }
         connection.Close();
      }
   }
}

Imports System.Data
Imports System.Data.SqlClient

Module Module1
   Sub Main()
      Using connection As New SqlConnection("Data Source=(local);Initial Catalog=AdventureWorks2012;Integrated Security=SSPI")
         Dim command As New SqlCommand("SELECT p.FirstName, p.MiddleName, p.LastName FROM HumanResources.Employee AS e" & _
                                       " JOIN Person.Person AS p ON e.BusinessEntityID = p.BusinessEntityID;", connection)
         connection.Open()
         Dim reader As SqlDataReader = command.ExecuteReader()
         While reader.Read()
            Console.Write(reader.GetString(reader.GetOrdinal("FirstName")))

            ' display middle name only of not null
            If Not reader.IsDBNull(reader.GetOrdinal("MiddleName")) Then
               Console.Write(" {0}", reader.GetString(reader.GetOrdinal("MiddleName")))
            End If

            Console.WriteLine(" {0}", reader.GetString(reader.GetOrdinal("LastName")))
         End While
         connection.Close()
      End Using
   End Sub
End Module

Berlaku untuk

Lihat juga