CSharpTest.Net
IsDBNull Method
See Also  Example Send Feedback Download Help File
CSharpTest.Net.Library Assembly > CSharpTest.Net.Data Namespace > CsvReader Class : IsDBNull Method

i

Glossary Item Box

Return whether the specified field is set to null.

Syntax

Visual Basic (Declaration) 
Public Function IsDBNull( _
   ByVal i As Integer _
) As Boolean
C# 
public bool IsDBNull( 
   int i
)

Parameters

i

Example

Library/Library.Test/TestCsvReader.cs

C#Copy Code
using (CsvReader r = new CsvReader(new StringReader(CSV_DOC1)))
{
    Assert.AreEqual(0, r.Depth);
    Assert.IsFalse(r.IsClosed);
    Assert.AreEqual(3, r.FieldCount);
    Assert.IsTrue(r.Read());
    Assert.AreEqual(3, r.FieldCount);
    Assert.IsTrue(r.Read());
    
    //second row has an extra field
    Assert.AreEqual(4, r.FieldCount);
    Assert.AreEqual("3", r.GetName(3));
    Assert.AreEqual(3, r.GetOrdinal("3"));
    Assert.AreEqual("extra", r.GetValue(3));

    Assert.IsTrue(r.Read());
    Assert.IsFalse(r.IsDBNull(0));
    Assert.AreEqual("3a", r.GetString("f1"));
    Assert.IsTrue(r.IsDBNull(1));
    Assert.IsTrue(r.IsDBNull(2));

    Assert.IsTrue(r.Read());
    Assert.IsTrue(r.Read());
    Assert.IsFalse(r.Read());
}
VB.NETCopy Code
Using r As New CsvReader(New StringReader(CSV_DOC1))
    Assert.AreEqual(0, r.Depth)
    Assert.IsFalse(r.IsClosed)
    Assert.AreEqual(3, r.FieldCount)
    Assert.IsTrue(r.Read())
    Assert.AreEqual(3, r.FieldCount)
    Assert.IsTrue(r.Read())

    'second row has an extra field
    Assert.AreEqual(4, r.FieldCount)
    Assert.AreEqual("3", r.GetName(3))
    Assert.AreEqual(3, r.GetOrdinal("3"))
    Assert.AreEqual("extra", r.GetValue(3))

    Assert.IsTrue(r.Read())
    Assert.IsFalse(r.IsDBNull(0))
    Assert.AreEqual("3a", r.GetString("f1"))
    Assert.IsTrue(r.IsDBNull(1))
    Assert.IsTrue(r.IsDBNull(2))

    Assert.IsTrue(r.Read())
    Assert.IsTrue(r.Read())
    Assert.IsFalse(r.Read())
End Using

Requirements

Target Platforms: Windows XP, Windows Server 2003, Windows Vista, Windows Server 2008, Windows 7

See Also

Generated with Document! X 2011 by Innovasys