Capture Sql Error(Using Resouce file)

See more:

C#

Windows

C#4.0

application

I have to catch system exceptions and Sql exceptions and have to display my own exceptions to users. Instead of using a table to store error message and error id, have to use Resourse file in my windows application. Can anyone give an idea to do this.

<b>Sql exception number My exception number my message to user</b>
411 1 Invalid Value
415 2 Empty values not allowed
417 3 DB not connected