work around for null or no data when reading from sql table

[manared]

Quick question:
When I'm reading data from a table in SQL, I want to bring back all the information and show it in my aspx page. But, if there is no data or if it's null, it throws an error. What do you think would be the easiest way to get around this? There is a LOT of fields to go through and I'd rather not use if statements for each one. Any ideas? Thank you!!

 

[Arg81]

ASP? You've posted to the wrong forum (vb.net data access gives it away..)

BTW, what error does it throw? What code do you use?
I've got a small ASP app that shows all the information from a table even if a row has a null column in the SQL table.

 

[manared]

haha.... oops!! yup, wrong forrum.. I'll repost it in the other one. And I'm using vb.net 2005 with SQL 2005.

I've gotten one error saying that it can't read because there is no data present and one error saying that it can't read a null value.

 

[cjard]

haha.... oops!! yup, wrong forrum.. I'll repost it in the other one.

Please dont cross-post. Instead, PM a moderator (JohnH, jmcilhinney, JuggaloBrotha, Paszt, Neal) and ask them to move the thread for you.