Datagrid with DBNull

[plopez]

Hi,
I have populated a Datagrid with an Access Table and now I need to send this values to a text file .

When I use StreamWriter to populate the text file,I notice that some cells in the grid have DBNull values and they cannot be read as String ?????

What is the right way to do this ...?

I need to solve this problem to continue with my App. so I apreciate your help.

 

[chrissie1]

there is a isdbnull function

so

if isdbnull(field) then
write = ""
else
write = whatever
end if

Christiaan Baes
Belgium

"My new site" - Me