Prev: FTP Site
Next: Crystal Reports 'Logon failed' problem
From: Miro on 4 Oct 2010 21:56 Hi, I have been struggling with this for a long time now and I cant seem to find a solution. I have a typed dataset with an int32 column ( that I just added to an access database ). So now within the database I have dbnull's in all the old records that did not have this int32. So if I read my field I get an exception error. I put this simple code infront of the code as I have been googling around: Dim IDNullError As Boolean = False If ShoppingCartBibCustomRow.IsFrontColorIDNull Then IDNullError = True Else IDNullError = False End If but it always returns FALSE - never true. In the "Immediate Window" for debugging: ? ShoppingCartBibCustomRow.IsFrontColorIDNull False but if I look at the value in the Locals tab... + FrontNameColorID {"The value for column 'FrontNameColorID' in table 'ShoppingCartBibCustom' is DBNull."} Integer so If I actaully do this in the "Immediate window", ? ShoppingCartBibCustomRow.FrontNameColorID ill get the exception: A first chance exception of type 'System.InvalidCastException' occurred in Microsoft.VisualBasic.dll A first chance exception of type 'System.Data.StrongTypingException' occurred in App_Code.rd6a6lcl.dll So why does it not return that it is a null value in the first place. Thank you, Miro
From: Mr. Arnold on 5 Oct 2010 07:14 On 10/4/2010 9:56 PM, Miro wrote: > Hi, > > I have been struggling with this for a long time now and I cant seem to > find a solution. > I have a typed dataset with an int32 column ( that I just added to an > access database ). > > So now within the database I have dbnull's in all the old records that > did not have this int32. > So if I read my field I get an exception error. > > I put this simple code infront of the code as I have been googling around: > Dim IDNullError As Boolean = False > > If ShoppingCartBibCustomRow.IsFrontColorIDNull Then > IDNullError = True > Else > IDNullError = False > End If > > but it always returns FALSE - never true. > In the "Immediate Window" for debugging: > ? ShoppingCartBibCustomRow.IsFrontColorIDNull > False > > but if I look at the value in the Locals tab... > + FrontNameColorID {"The value for column 'FrontNameColorID' in table > 'ShoppingCartBibCustom' is DBNull."} Integer > > > so If I actaully do this in the "Immediate window", > ? ShoppingCartBibCustomRow.FrontNameColorID > ill get the exception: > A first chance exception of type 'System.InvalidCastException' occurred > in Microsoft.VisualBasic.dll > A first chance exception of type 'System.Data.StrongTypingException' > occurred in App_Code.rd6a6lcl.dll > > So why does it not return that it is a null value in the first place. > > Thank you, > > Miro I think you're going to need to check the object for being null. If ShoppingCartBibCustomRow.FrontNameColorID == null. Everything in .NET is an object. So you should check for something being an object. It's not an object if it's null.
From: Miro on 5 Oct 2010 09:02 The problem is that you cannot. The second you do anything with this line: ShoppingCartBibCustomRow.FrontNameColorID the typed dataset throws an exception. You cannot change in the typed dataset 'not to' throw an exception. It only allows you to set the "on Null return empty / null " on strings. So I would like to check for null - but I cant even check as the exception comes out. M. "Mr. Arnold" <Arnold(a)Arnold.com> wrote in message news:#DKYt5HZLHA.620(a)TK2MSFTNGP05.phx.gbl... > On 10/4/2010 9:56 PM, Miro wrote: >> Hi, >> >> I have been struggling with this for a long time now and I cant seem to >> find a solution. >> I have a typed dataset with an int32 column ( that I just added to an >> access database ). >> >> So now within the database I have dbnull's in all the old records that >> did not have this int32. >> So if I read my field I get an exception error. >> >> I put this simple code infront of the code as I have been googling >> around: >> Dim IDNullError As Boolean = False >> >> If ShoppingCartBibCustomRow.IsFrontColorIDNull Then >> IDNullError = True >> Else >> IDNullError = False >> End If >> >> but it always returns FALSE - never true. >> In the "Immediate Window" for debugging: >> ? ShoppingCartBibCustomRow.IsFrontColorIDNull >> False >> >> but if I look at the value in the Locals tab... >> + FrontNameColorID {"The value for column 'FrontNameColorID' in table >> 'ShoppingCartBibCustom' is DBNull."} Integer >> >> >> so If I actaully do this in the "Immediate window", >> ? ShoppingCartBibCustomRow.FrontNameColorID >> ill get the exception: >> A first chance exception of type 'System.InvalidCastException' occurred >> in Microsoft.VisualBasic.dll >> A first chance exception of type 'System.Data.StrongTypingException' >> occurred in App_Code.rd6a6lcl.dll >> >> So why does it not return that it is a null value in the first place. >> >> Thank you, >> >> Miro > > I think you're going to need to check the object for being null. > > If ShoppingCartBibCustomRow.FrontNameColorID == null. > > Everything in .NET is an object. So you should check for something being > an object. It's not an object if it's null. >
From: Cubaman on 6 Oct 2010 03:37 On Oct 5, 3:56 am, "Miro" <m...(a)beero.com> wrote: > Hi, > > I have been struggling with this for a long time now and I cant seem to find > a solution. > I have a typed dataset with an int32 column ( that I just added to an access > database ). > > So now within the database I have dbnull's in all the old records that did > not have this int32. > So if I read my field I get an exception error. > > I put this simple code infront of the code as I have been googling around: > Dim IDNullError As Boolean = False > > If ShoppingCartBibCustomRow.IsFrontColorIDNull Then > IDNullError = True > Else > IDNullError = False > End If > > but it always returns FALSE - never true. > In the "Immediate Window" for debugging: > ? ShoppingCartBibCustomRow.IsFrontColorIDNull > False > > but if I look at the value in the Locals tab... > + FrontNameColorID {"The value for column 'FrontNameColorID' in table > 'ShoppingCartBibCustom' is DBNull."} Integer > > so If I actaully do this in the "Immediate window", > ? ShoppingCartBibCustomRow.FrontNameColorID > ill get the exception: > A first chance exception of type 'System.InvalidCastException' occurred in > Microsoft.VisualBasic.dll > A first chance exception of type 'System.Data.StrongTypingException' > occurred in App_Code.rd6a6lcl.dll > > So why does it not return that it is a null value in the first place. > > Thank you, > > Miro The DBNull type is a singleton class, which means only one DBNull object exists. The DBNull.Value member represents the sole DBNull object. DBNull.Value can be used to explicitly assign a nonexistent value to a database field, although most ADO.NET data providers automatically assign values of DBNull when a field does not have a valid value. You can determine whether a value retrieved from a database field is a DBNull value by passing the value of that field to the DBNull.Value.Equals method. However, some languages and database objects supply methods that make it easier to determine whether the value of a database field is DBNull.Value. These include the Visual Basic IsDBNull function, the Convert.IsDBNull method, the DataTableReader.IsDBNull method, and the IDataRecord.IsDBNull method. Do not confuse the notion of null in an object-oriented programming language with a DBNull object. In an object-oriented programming language, null means the absence of a reference to an object. DBNull represents an uninitialized variant or nonexistent database column. http://msdn.microsoft.com/en-us/library/system.dbnull.aspx Best regards
From: Jason Keats on 6 Oct 2010 09:16 Miro wrote: > > The second you do anything with this line: > ShoppingCartBibCustomRow.FrontNameColorID > the typed dataset throws an exception. > You cannot change in the typed dataset 'not to' throw an exception. > It only allows you to set the "on Null return empty / null " on strings. > > So I would like to check for null - but I cant even check as the > exception comes out. > Doesn't every nullable column in a typed dataset have an Is[ColumnName]Null() method? Alternatively, you can annotate your XSD using the nullValue attribute... http://ondotnet.com/pub/a/dotnet/2003/03/31/typeddatasetannotations.html
|
Pages: 1 Prev: FTP Site Next: Crystal Reports 'Logon failed' problem |