I have problem on stored procedure after executing it

This is the select statement inside the stored procedure:
select sum(amt) as total from orders where order_Date = today

The problem occurs when there is no record or orders on a specific date.
How could I check if the value returned is null or there is no record found in vb.net?

Hope someone could help me on this. Thanks!!!