I searched high and low and did not find any VB.net samples. you may want
to cross-post to:
http://groups.yahoo.com/group/ASPNET_SQLSERVER/
and
intm-dl.sparklist.com/.../lyris.pl\
ish
and
www.asp.net/.../ShowForum.aspx
to see if you get answers there.

For those who do not know about notifications and want to learn more:
http://www.microsoft.com/sql/ns/default.asp
is the home of the notification  services.

msdn.microsoft.com/.../def\
ault.aspx
is also an overview.

Some powerpoints:
http://www.stlnet.org/uploads/SQLNS_STLNET.ppt
technet.microsoft.at/includes/file.asp?ID=3382