I am using the IIF function in my application to create an instance and
value of a field if it doesn't exist in the query. I am using a
datagrid to display 4-5 items at a time and if one of the items doesn't
have a revision listed in tblRevisions then the whole page errors out.
I am using the following to try and fix the problem:
Dim intADCN As Integer =
IIf(ds1.Tables("DataTable").Rows(0)("RevNumber") Is Nothing, 0,
ds.Tables("DataTable").Rows(0)("RevNumber"))
I am getting an error: Cast from type 'DBNull' to type 'Integer' is not
valid. It seems as though instead of creating the instance and value of
0, it is simply creating the instance of there being an a row there and
the value is null.
Am I missing something or does anyone have any suggestions?
5  4001 
Taken from your example, this will return 0 if the value is Null, else the
value:
Dim intADCN As Integer = "0" & ds1.Tables("DataTable").Rows(0)("RevNumber")
"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com... I am using the IIF function in my application to create an instance and
value of a field if it doesn't exist in the query. I am using a
datagrid to display 4-5 items at a time and if one of the items doesn't
have a revision listed in tblRevisions then the whole page errors out.
I am using the following to try and fix the problem:
Dim intADCN As Integer =
IIf(ds1.Tables("DataTable").Rows(0)("RevNumber") Is Nothing, 0,
ds.Tables("DataTable").Rows(0)("RevNumber"))
I am getting an error: Cast from type 'DBNull' to type 'Integer' is not
valid. It seems as though instead of creating the instance and value of
0, it is simply creating the instance of there being an a row there and
the value is null.
Am I missing something or does anyone have any suggestions?
I fixed it!
Dim intRevNumber As Integer
If ds.Tables("DataTable").Rows(0)("RevNumber") Is DBNull.Value Then
intRevNumber = 0
Else
intRevNumber = ds.Tables("DataTable").Rows(0)("RevNumber")
End If
Good Buddy
"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com... I fixed it!
Dim intRevNumber As Integer
If ds.Tables("DataTable").Rows(0)("RevNumber") Is DBNull.Value Then
intRevNumber = 0
Else
intRevNumber = ds.Tables("DataTable").Rows(0)("RevNumber")
End If
> Dim intADCN As Integer = "0" & ds1.Tables("DataTable").Rows(0)("RevNumber")
Turning Option Strict Off is extremely bad practice, and the above code is a
horrible example of why. You're treating BOTH a string and possibly Nothing
as an Integer. You're also occasionally concatenating Nothing to a String.
This sort of coding can lead to all kinds of debugging headaches, as well as
not throwing exceptions that should be thrown, thus enabling your app to
pass the smell test in testing, and fail behind your back in production.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
"Chris Botha" <ch***********@AThotmail.com> wrote in message
news:eH**************@TK2MSFTNGP14.phx.gbl... Taken from your example, this will return 0 if the value is Null, else the
value:
Dim intADCN As Integer = "0" &
ds1.Tables("DataTable").Rows(0)("RevNumber")
"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...I am using the IIF function in my application to create an instance and
value of a field if it doesn't exist in the query. I am using a
datagrid to display 4-5 items at a time and if one of the items doesn't
have a revision listed in tblRevisions then the whole page errors out.
I am using the following to try and fix the problem:
Dim intADCN As Integer =
IIf(ds1.Tables("DataTable").Rows(0)("RevNumber") Is Nothing, 0,
ds.Tables("DataTable").Rows(0)("RevNumber"))
I am getting an error: Cast from type 'DBNull' to type 'Integer' is not
valid. It seems as though instead of creating the instance and value of
0, it is simply creating the instance of there being an a row there and
the value is null.
Am I missing something or does anyone have any suggestions?
I've been doing this since the days of VB6 and ADO, no problems yet.
Thanks for the comments though.
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:ec**************@TK2MSFTNGP15.phx.gbl... Dim intADCN As Integer = "0" &
ds1.Tables("DataTable").Rows(0)("RevNumber")
Turning Option Strict Off is extremely bad practice, and the above code is
a horrible example of why. You're treating BOTH a string and possibly
Nothing as an Integer. You're also occasionally concatenating Nothing to a
String. This sort of coding can lead to all kinds of debugging headaches,
as well as not throwing exceptions that should be thrown, thus enabling
your app to pass the smell test in testing, and fail behind your back in
production.
--
HTH,
Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.
"Chris Botha" <ch***********@AThotmail.com> wrote in message
news:eH**************@TK2MSFTNGP14.phx.gbl... Taken from your example, this will return 0 if the value is Null, else
the value:
Dim intADCN As Integer = "0" &
ds1.Tables("DataTable").Rows(0)("RevNumber")
"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...I am using the IIF function in my application to create an instance and
value of a field if it doesn't exist in the query. I am using a
datagrid to display 4-5 items at a time and if one of the items doesn't
have a revision listed in tblRevisions then the whole page errors out.
I am using the following to try and fix the problem:
Dim intADCN As Integer =
IIf(ds1.Tables("DataTable").Rows(0)("RevNumber") Is Nothing, 0,
ds.Tables("DataTable").Rows(0)("RevNumber"))
I am getting an error: Cast from type 'DBNull' to type 'Integer' is not
valid. It seems as though instead of creating the instance and value of
0, it is simply creating the instance of there being an a row there and
the value is null.
Am I missing something or does anyone have any suggestions?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: domeceo |
last post by:
can anyone tell me why I cannot pass values in a setTimeout function
whenever I use this function it says "menu is undefined" after th
alert.
function imgOff(menu, num) {
if (document.images) {...
|
by: phil_gg04 |
last post by:
Dear Javascript Experts,
Opera seems to have different ideas about the visibility of Javascript
functions than other browsers. For example, if I have this code:
if (1==2) {
function...
|
by: laredotornado |
last post by:
Hello, I am looking for a cross-browser way (Firefox 1+, IE 5.5+) to
have my Javascript function execute from the BODY's "onload" method,
but if there is already an onload method defined, I would...
|
by: sushil |
last post by:
+1 #include<stdio.h>
+2 #include <stdlib.h>
+3 typedef struct
+4 {
+5 unsigned int PID;
+6 unsigned int CID;
+7 } T_ID;
+8
+9 typedef unsigned int (*T_HANDLER)(void);
+10
|
by: Olov Johansson |
last post by:
I just found out that JavaScript 1.5 (I tested this with Firefox 1.0.7
and Konqueror 3.5) has support not only for standard function
definitions, function expressions (lambdas) and Function...
|
by: Beta What |
last post by:
Hello,
I have a question about casting a function pointer. Say I want to make
a generic module (say some ADT implementation) that requires a function
pointer from the 'actual/other modules'...
|
by: f rom |
last post by:
----- Forwarded Message ----
From: Josiah Carlson <jcarlson@uci.edu>
To: f rom <etaoinbe@yahoo.com>; wxpython-users@lists.wxwidgets.org
Sent: Monday, December 4, 2006 10:03:28 PM
Subject: Re: ...
|
by: Larax |
last post by:
Best explanation of my question will be an example, look below at this
simple function:
function SetEventHandler(element)
{
// some operations on element
element.onclick =
function(event)
{
|
by: alex |
last post by:
I am so confused with these three concept,who can explained it?thanks
so much?
e.g.
var f= new Function("x", "y", "return x * y");
function f(x,y){
return x*y
}
var f=function(x,y){
|
by: VK |
last post by:
I was getting this effect N times but each time I was in rush to just
make it work, and later I coudn't recall anymore what was the original
state I was working around. This time I nailed the...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
