Big Problem

[jewly]

I would be soooooo grateful if someone could give me an answer to this. I am taking data from Excel to VB.NET and validating it within the VB.NET program. Some of the data in the spreadsheet comes out as dbnull. I am currently converting the data to a string becuase of this but need to do some calculation on it so it needs to be in int format. Is there any way of converting a dbnull to some type of numerical integer?

Thank you so much

Julie

[Dewwd]

I'd assume you are assigning the values taken from Excel to variables or integers, so I'd use a If... Then.. statement or somthing with the IsDBNull method. for example:

If IsDBNull(Whatever) then
Whatever = "<This field is Null>"
End If

Thats best I can do without seeing some of your code or knowing exactly what you are doing. But if you need any more help feel free to email me at [email protected].

[wossname]

Well, it rather depends on how you are calculating things.

if whatever is dbnull.value then myValue = 0

Might work or it might not depending on your formulae.

Alternatively, using Single instead of integer will let you use Single.Nan in stead of the zero above. It won't be a numerical value but it will be a single.

[jewly]

Thank you for your help.Because it is going straight into a database I would rather not program another if statement.

at the moment this works dr("value").ToString
BUT
it doenst work for values with a minus and saying to int will not work on dbnull!!such a dilemma,are there any other datatypes which could possibly handle this?

[wossname]

Because it is going straight into a database I would rather not program another if statement.

I'm having trouble understanding your situation. Can you post the chunk of code that you are having problems with (ie the whole subroutine).

I see you have 2 further options:
1. Write a class or a structure that can handle the problem and still be used in formulas.
2. use an IF statement (why don't you like if statements?)