public static string ShowErrors(System.Data.SqlClient.SqlException e) { StringBuilder bld = new StringBuilder(); Exception inner = e.InnerException; if (null != inner) { bld.Append("Inner Exception: " + inner.ToString()); } if (e.Errors != null) { System.Data.SqlClient.SqlErrorCollection errorCollection = e.Errors; foreach (System.Data.SqlClient.SqlError err in errorCollection) { bld.AppendLine("Message : " + err.Message); bld.AppendLine("Level : " + err.Class); bld.AppendLine("State : " + err.State); bld.AppendLine("Procedure : " + err.Procedure); bld.AppendLine("Line : " + err.LineNumber); bld.AppendLine("Source : " + err.Source); bld.AppendLine("Number : " + err.Number); bld.AppendLine("Server : " + err.Server); } } return(bld.ToString()); }
private static void ShowErrors(System.Data.SqlClient.SqlException e) { System.Data.SqlClient.SqlErrorCollection errorCollection = e.Errors; StringBuilder bld = new StringBuilder(); Exception inner = e.InnerException; // Enumerate the errors to a message box. foreach (System.Data.SqlClient.SqlError err in errorCollection) { bld.Append("\n Message : " + err.Message); bld.Append("\n Source : " + err.Source); bld.Append("\n Number : " + err.Number); bld.Remove(0, bld.Length); } }
public static string ShowErrors(System.Data.SqlClient.SqlException e) { System.Data.SqlClient.SqlErrorCollection errorCollection = e.Errors; StringBuilder bld = new StringBuilder(); Exception inner = e.InnerException; if (null != inner) { bld.Append("Inner Exception: " + inner.ToString()); } // Enumerate the errors to a message box. foreach (System.Data.SqlClient.SqlError err in errorCollection) { bld.Append("\n Message : " + err.Message); bld.Append("\n Source : " + err.Source); bld.Append("\n Number : " + err.Number); } return(bld.ToString()); }