My application allows users to change data in a grid and update the values within my sas data tables. That part works correctly. What I need to know is how to capture an error that sas throws and return it to my windows application and display it?
What's the context here? Is this a custom task within EG or just a Windows app that you created with .NET?
If you are using the IOM LanguageService to issue a query (PROC SQL UPDATE), you would need to use the FlushLog or FlushLogLines call to get the SAS log, which would contain any errors/warning along with the rest of the SAS log.
If this is a custom task, there are are some wrapper classes that I can point you to. If that's the case, then we need to know whether this is EG 4.1 or 4.2.
First, IOM requires that you have SAS Integration Technologies on your server. So if you have that, it's a good start.
IOM offers the LanguageService interface to allow you to run SAS programs and gather the logs and results. You can also access data like you do now, but using the SAS IOM OLE DB provider.
If all you need to do is treat your SAS/Share server like a database, then your current approach is probably fine. Are you using ADO or ADO.NET? And do you have a more complete C# example for how you are working with this? That would help our experts here to give advice.
This isn't exactly the correct forum for this, but I know there probably isn't another that is a better fit.