Which event of the SqlConnection class can be used to retreive error information

from a database ?

InfoMessage is the event. More details on this http://www.codeproject.com/KB/database/infomessage.aspx

StateChanged occurs when the state of the event changes from open to closed or viceversa

There is no event like MessageReceived.