Return Values from a DataAdapter

[EStallworth]

I have a dataadapter that looks for previous balances within a dataset. Not all parameters defined for the dataadapter will return values. What I am wondering is how do you reference this null value within the object. What I am trying to do is attach a string to the values within the objects(textboxes) while converting the value to decimal by using Cdec. Only problem is that it does not work on null values. So what I am trying to do is when a null value is received, I would like to insert 0.00 into the object in order for the string attachment to work. I have tried the following:

If Val(previousadjustlabel.text).Equals("") Then
     previousadjustlabel.text = "0.00"
End If

and

If Val(previousadjustlabel.Text).Equals(Nothing) Then
     previousadjustlabel.text = "0.00"
End If

Any suggestions guys?

 

[lingsn]

May be can try

previousadjustlabel.text = format(val(previousadjustlabel.text),"######0.00")

 

[EStallworth]

Yes this works! Thx dude!