Can anyone advise if this is possible and how this can be achieved.
Regards Kieran One similar application I have comes to mind.
For example, Sql server has a Line Number property that lists the line number of a stored procedure causing an error.
I am developing an application and using the VS2008 Data Grid View control. In the example of the Ole Db Execution object in Listing 5-59, the Error collection of the exception is looped through after the exception is thrown, and both the error messages and the error codes are placed in a string to be printed out in a Message Box control. Utilizing the Ole Db Error Collection Listing 5-60 used the Sql Server Exception class. The Sql Error is a bit more extensive in that it can tell you more an error than the Ole Db Error. Sql Error Properties Info Message Event Handler: Listening to Warnings Information or warning message is sometimes produced after a query is executed on a database. NET project: The message Box in this code shows the first information message passed in form the Info Message Event argument.You print the server name, message, and error code in a message box. This event argument contains an Error Collection much the same way an Exception object contains an Error Colelction.The Sql data provider provides some additional methods for dealing with transactions involving save points.Save points allow you to rollback to a "bookmarked" point in the transaction. As you can see from Listing 5-58, first you establish a connection with the Northwind database and open the connection.