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());
}
