Hi,

In both SQL Server and VB.NET you have to use Try catch block.

What ever error you grab in SQL Server catch box just Raised it with RAISERROR syntax.

Now in VB.NET you can capture this and show or do what ever operation you want.