Handle DBNull in C#

Posted by Andreas on Stack Overflow See other posts from Stack Overflow or by Andreas
Published on 2010-03-12T13:56:25Z Indexed on 2010/03/12 13:57 UTC
Read the original article Hit count: 358

Filed under:

convert

|

dbnull

|

int

|

c#

Is there a better/cleaner way to do this?

int stockvalue = 0;
if (!Convert.IsDBNull(reader["StockValue"]))
    stockvalue = (int)reader["StockValue"];

© Stack Overflow or respective owner

Related posts about convert

Monitoring SQL Server Agent job run times

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Introduction A few months back, I was asked how long a particular nightly process took to run. It was a super question and the one thing that struck me was that there were a plethora of factors affecting the processing time. This said, I developed a query to ascertain process run times, the… >>> More
Convert Dynamic to Type and convert Type to Dynamic

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
public static class DynamicExtensions { public static T FromDynamic<T>(this IDictionary<string, object> dictionary) { var bindings = new List<MemberBinding>(); foreach (var sourceProperty in typeof(T).GetProperties().Where(x => x… >>> More
Need help in filtering the data with various condition and filling in scroll window GP

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am filtering the data and displaying in scroll window. There are many combination to display this data by customer id, customer id and itemnumber, customer id, itemnumber, work and history condition. And from date and To date condition. My query is when I am selecting the customer id and… >>> More
Convert and convert back datetime in Django

as seen on Stack Overflow - Search for 'Stack Overflow'
I am parsing feeds using feedparser and I am trying to store updated or updated_parsed attributes of feeds in Django db. But it shows an error as [u'Enter a valid date/time in YYYY-MM-DD HH:MM[:ss[.uuuuuu]] format.'] Please tell me how to convert updated and updated_parsed such that it can be stored… >>> More
Redaction in AutoVue

as seen on Oracle Blogs - Search for 'Oracle Blogs'
As the trend to digitize all paper assets continues, so does the push to digitize all the processes around these assets. One such process is redaction - removing sensitive or classified information from documents. While for some this may conjure up thoughts of old CIA documents filled with nothing… >>> More

Related posts about dbnull

ASP.Net check value with DBNULL

as seen on Stack Overflow - Search for 'Stack Overflow'
hey all, i have the following code foreach (DataRowView dr in Data) { if (dr == System.DBNull.Value) { nedID = 1; } } but i get the following error Operator '==' cannot be applied to operands of type 'System.Data.DataRowView'… >>> More
Filtering DBNull With LINQ

as seen on Stack Overflow - Search for 'Stack Overflow'
Why does the following query raise the error below for a row with a NULL value for barrel when I explicitly filter out those rows in the Where clause? Dim query = From row As dbDataSet.conformalRow In dbDataSet.Tables("conformal") _ Where Not IsDBNull(row.Cal) AndAlso tiCal_drop.Text… >>> More
Handle DBNull in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a better/cleaner way to do this? int stockvalue = 0; if (!Convert.IsDBNull(reader["StockValue"])) stockvalue = (int)reader["StockValue"]; >>> More
DBnull in Linq query causing problems

as seen on Stack Overflow - Search for 'Stack Overflow'
hi there i am doing a query thus: int numberInInterval = (from dsStatistics.J2RespondentRow item in jStats.J2Respondent where item.EndTime > dtIntervalLower && item.EndTime <= dtIntervalUpper select item).count(); there appear to be some dbnulls… >>> More
Most efficient way to check for DBNull and then assign to a variable?

as seen on Stack Overflow - Search for 'Stack Overflow'
This question comes up occasionally but I haven't seen a satisfactory answer. A typical pattern is (row is a DataRow): if (row["value"] != DBNull.Value) { someObject.Member = row["value"]; } My first question is which is more efficient (I've flipped the condition): row["value"] ==… >>> More