This error is what circumstance, I also wrote before no error
With the CSng is incorrect

CodePudding user response:

Before assigning check data which can effectively prevent such problems

CodePudding user response:

Database a value is Null, the simple assignment before if a judge can,

CodePudding user response:

That data inside the database "RZSL" value is null

CodePudding user response:

Loop line "RZSL" field in the database is null values, using the time of processing the, or SQL statements ISNULL (" RZSL ", ""),

CodePudding user response:

I directly to 0, all empty

CodePudding user response:

. After the ToString

CodePudding user response:

Data value transformation problem, ToString transformation!

CodePudding user response:

If XXX is dbnull. Value then
The Continue For

CodePudding user response:

Not have monitoring and immediately below the window? Check the item of value, immediately in front of the window to make a question mark, for example? i

CodePudding user response:

I use is a function of processing, will be null to a string

CodePudding user response:

 

IF NOT IsDBNull (tapics. Tables (0). The Rows (j). The Item (" RPZSL ")) then 
The Cell (I). PzsL=tapics. Tables (0). The Rows (j). The Item (" RPZSL ") 
End the If 

CodePudding user response:

If the row. Isnull (" field name ")=false then XXXXXX

CodePudding user response:

Is this your database, RPZSL this line of this field is NULL, you can replace the select RPZSL in select statements for the select isnull (RPZSL, ' ') as RPZSL