C# - get at return value from read of sql database

I am a nebbie to .net!

I am changing an application which reads an sql database - (does a param search) .

I need to be able to output a message to screen when no records exist for search.

Application is using a Repeater which reads - data table to output records to the application.

The query to the database is in a different class.

Can get message to output on screen when I force, so I know the syntax is working.  I just need to know how I can get at return (bool - true/false) so I can test on this.

Can anyone out there help?