Hi all,

I'm new to ASP .NET and I know this would be a simple tasks in ASP but I have no idea how to do it in .NET


I have several stored procedures on a page producing datasets that are bound to label boxes on the page. Given the nature of the data, sometimes no results will come back from 1 or more of the stored procedures. When no results are returned, the application returns the error "Index 0 is not non-negative and below total rows count"

Is there a way I can trap for this so the page does not error out? Is there a way to continue with the execution of the page and just display nothing in the labels with empty datasets?


Thanks in advance.

Evan

Try this:

IF ds.Tables(<tablename>).Rows.Count > 0 THEN
   Label.Databind
End If

Thanks. Nailed it!