-
-
THE ABOVE IS THE XML DATA. Here i got all the tag value, but interest tag value i m not able to get that, because if this tag contain null value means how to get that and store in the database. The interest field defined as numeric in the database(sql server) so it does not accept null we want to save it as 0.
i tried the following method also
Convert.Toint32datareader("INTEREST") but i could not solve the problem
post solution for this post
WISH U HAPPY NEW YEAR
Thanks in Advance
VulpesPosted Dec 31, 2011, 6:57 AM
Dim number As Integer;
Int32.TryParse(datareader("INTEREST"), number) 'EDITED
then it will automatically set number to zero if the INTEREST tag contains an empty string, or otherwise convert it to an integer.
That's the best that you can do unless the column is nullable.