.Net SqlDataReader Item is Null [VB]
By : userK
Date : March 29 2020, 07:55 AM
wish helps you IIf always evaluates both the true and false parts - use inline If instead if you want to avoid this: code :
While dr.Read()
corporateTable.Rows.Add(New Object() { _
Convert.ToDateTime(dr("EventBeginDate")) _
, If(dr("EventEndDate") Is DBNull.Value, Convert.ToDateTime(dr("EventBeginDate")).AddDays(1), Convert.ToDateTime(dr("EventEndDate"))) _
, Convert.ToString(dr("EventType")) _
, Convert.ToString(dr("EventDescription")) _
, Convert.ToString(dr("EventMessage")) _
})
End While
|
SQLDataReader Null to datetime
By : Kartik Kannao
Date : March 29 2020, 07:55 AM
it fixes the issue Having an issue with casting a datetime from a reader where the value is null. , I suspect you meant: code :
form._date101 = reader[52] == DBNull.Value ? null : (DateTime?)reader[52];
|
how to get null values in sqldatareader
By : kishan
Date : March 29 2020, 07:55 AM
I hope this helps you . You can use the IsDBNull method. Something like that: code :
int ordinal_so_type=reader.GetOrdinal("so_type");
//...
while(reader.Read()==true)
{
//reading other columns here
if (reader.IsDBNull(ordinal_so_type)==false)
{
s.type=reader.GetInt32(ordinal_so_type);
}
else
{
//do whatever you like if the so_type column is null
}
}
|
SqlDataReader Best way to check for null values -sqlDataReader.IsDBNull vs DBNull.Value
By : Capo Benn
Date : March 29 2020, 07:55 AM
I wish this help you I would not get too caught up in the which method is better, because both work and I have used both in code before. For instance, here is a utility function I dug up from one of my old projects: code :
/// <summary>
/// Helper class for SqlDataReader, which allows for the calling code to retrieve a value in a generic fashion.
/// </summary>
public static class SqlReaderHelper
{
private static bool IsNullableType(Type theValueType)
{
return (theValueType.IsGenericType && theValueType.GetGenericTypeDefinition().Equals(typeof(Nullable<>)));
}
/// <summary>
/// Returns the value, of type T, from the SqlDataReader, accounting for both generic and non-generic types.
/// </summary>
/// <typeparam name="T">T, type applied</typeparam>
/// <param name="theReader">The SqlDataReader object that queried the database</param>
/// <param name="theColumnName">The column of data to retrieve a value from</param>
/// <returns>T, type applied; default value of type if database value is null</returns>
public static T GetValue<T>(this SqlDataReader theReader, string theColumnName)
{
// Read the value out of the reader by string (column name); returns object
object theValue = theReader[theColumnName];
// Cast to the generic type applied to this method (i.e. int?)
Type theValueType = typeof(T);
// Check for null value from the database
if (DBNull.Value != theValue)
{
// We have a null, do we have a nullable type for T?
if (!IsNullableType(theValueType))
{
// No, this is not a nullable type so just change the value's type from object to T
return (T)Convert.ChangeType(theValue, theValueType);
}
else
{
// Yes, this is a nullable type so change the value's type from object to the underlying type of T
NullableConverter theNullableConverter = new NullableConverter(theValueType);
return (T)Convert.ChangeType(theValue, theNullableConverter.UnderlyingType);
}
}
// The value was null in the database, so return the default value for T; this will vary based on what T is (i.e. int has a default of 0)
return default(T);
}
}
yourSqlReaderObject.GetValue<int?>("SOME_ID_COLUMN");
yourSqlReaderObject.GetValue<string>("SOME_VALUE_COLUMN");
|
SqlDataReader returns null
By : Meganathan Develop
Date : March 29 2020, 07:55 AM
To fix the issue you can do You are adding the same four columns to the DataTable each time you load a row.
|