Dataset field DBNull -> int?

Posted by BobClegg on Stack Overflow See other posts from Stack Overflow or by BobClegg
Published on 2009-03-02T02:45:53Z Indexed on 2010/04/07 2:43 UTC
Read the original article Hit count: 407

Filed under:

dbnull

|

nullable

|

dataset

SQLServer int field. Value sometimes null. DataAdapter fills dataset OK and can display data in DatagridView OK.

When trying to retrieve the data programmatically from the dataset the Dataset field retrieval code throws a StronglyTypedException error.

 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    public int curr_reading {
        get {
            try {
                return ((int)(this[this.tableHistory.curr_readingColumn]));
            }
            catch (global::System.InvalidCastException e) {
                throw new global::System.Data.StrongTypingException("The value for column \'curr_reading\' in table \'History\' is DBNull.", e);
            }

Got past this by checking for DBNull in the get accessor and returning null but... When the dataset structure is modified (Still developing) my changes (unsurprisingly) are gone.

What is the best way to handle this situation? It seems I am stuck with dealing with it at the dataset level. Is there some sort of attribute that can tell the auto code generator to leave the changes in place?

© Stack Overflow or respective owner

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

Related posts about nullable

Nullable Type implementation without nullable feature of C#

as seen on Stack Overflow - Search for 'Stack Overflow'
How can we implement a nullable type in C# if we didn't have this feature in C#? >>> More
Nullable Enum nullable type question

as seen on Stack Overflow - Search for 'Stack Overflow'
I get the following compilation error with the following source code: Compilation Error: Type of conditional expression cannot be determined because there is no implicit conversion between '' and 'MyEnum' Source Code public enum MyEnum { Value1, Value2, Value3 } public class MyClass { … >>> More
Order by nullable property simultaneously with ordering by not nullable property in HQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a table called Users in my database. Let's assume that User has only 3 properties int ID; string? Name; string Login; If user doesn't specify his name then Login is displayed. Otherwise Name is displayed. I wan't to get list of all users sorted by what is displayed. So if user specified… >>> More
Nullable ToString()

as seen on Stack Overflow - Search for 'Stack Overflow'
I see everywhere constructions like: int? myVar = null; string test = myVar.HasValue ? myVar.Value.ToString() : string.Empty; Why not use simply: string test = myVar.ToString(); Isn't that exactly the same ? At least Reflector says that: public override string ToString() { if (!this… >>> More
LINQ-to-SQL IN/Contains() for Nullable<T>

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to generate this SQL statement in LINQ: select * from Foo where Value in ( 1, 2, 3 ) The tricky bit seems to be that Value is a column that allows nulls. The equivalent LINQ code would seem to be: IEnumerable<Foo> foos = MyDataContext.Foos; IEnumerable<int> values = GetMyValues(); var… >>> More