private void ConnectionContext_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
if (e.Errors != null && e.Errors.Count > 0)
{
int count = e.Errors.Count;
ScriptExecutorEventArgs[] args = new ScriptExecutorEventArgs[e.Errors.Count];
for (int i = 0; i < count; i++)
{
switch (e.Errors[i].Number)
{
case 100000:
args[i] = new ScriptExecutorEventArgs(ScriptExecutorEventArgs.EventMessageCode.ObjectCount, e.Errors[i].Message);
break;
case 100010:
args[i] = new ScriptExecutorEventArgs(ScriptExecutorEventArgs.EventMessageCode.Progress, e.Errors[i].Message);
break;
default:
args[i] = new ScriptExecutorEventArgs(ScriptExecutorEventArgs.EventMessageCode.SqlInfoMessage, e.Errors[i].Message);
break;
}
}
this.OnProgress(args);
}
else
{
Debug.Print("Huh " + e.Message);
}
}
public static void OnInfoMessage(object Sender, System.Data.SqlClient.SqlInfoMessageEventArgs Args)
{
string Vb_Tab = System.Convert.ToChar(9).ToString();
string Vb_Cr_Lf = System.Environment.NewLine;
foreach (System.Data.SqlClient.SqlError SqlErr in Args.Errors)
{
Print(Vb_Cr_Lf + System.DateTime.Now.ToString().Substring(0, 16) + " . The error occured on server `" + SqlErr.Server.ToString().Trim() + "` : " + SqlErr.Source.ToString().Trim() + Vb_Cr_Lf + Vb_Tab + ", has received a severity " + SqlErr.Class.ToString().Trim() + ", state " + SqlErr.State + " ,error number " + SqlErr.Number.ToString().Trim() + " , on line " + SqlErr.LineNumber.ToString().Trim() + " of procedure `" + SqlErr.Procedure.ToString().Trim() + "`" + Vb_Cr_Lf + Vb_Tab + SqlErr.Message.ToString().Trim().Replace(Vb_Cr_Lf, Vb_Cr_Lf + Vb_Tab) + Vb_Cr_Lf);
}
}
private static void SqlConnection_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
foreach (System.Data.SqlClient.SqlError r in e.Errors)
{
if (SqlErrorList == null)
{
SqlErrorList = new List<System.Data.SqlClient.SqlError>();
}
SqlErrorList.Add(r);
}
}
private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
}
private void Conn_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
MessageBox.Show(e.Message);
}
private void SqlConnection_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
Log.Info(e.Message);
}