public virtual List <MySqlError> ReportWarnings(MySqlConnection connection)
{
List <MySqlError> warnings = new List <MySqlError>();
MySqlCommand cmd = new MySqlCommand("SHOW WARNINGS", connection);
cmd.InternallyCreated = true;
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
warnings.Add(new MySqlError(reader.GetString(0),
reader.GetInt32(1), reader.GetString(2)));
}
}
MySqlInfoMessageEventArgs args = new MySqlInfoMessageEventArgs();
args.errors = warnings.ToArray();
if (connection != null)
{
connection.OnInfoMessage(args);
}
return(warnings);
}
public void ReportWarnings()
{
ArrayList errors = new ArrayList();
MySqlCommand cmd = new MySqlCommand("SHOW WARNINGS", connection);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
errors.Add(new MySqlError(reader.GetString(0),
reader.GetInt32(1), reader.GetString(2)));
}
hasWarnings = false;
// MySQL resets warnings before each statement, so a batch could indicate
// warnings when there aren't any
if (errors.Count == 0)
{
return;
}
MySqlInfoMessageEventArgs args = new MySqlInfoMessageEventArgs();
args.errors = (MySqlError[])errors.ToArray(typeof(MySqlError));
if (connection != null)
{
connection.OnInfoMessage(args);
}
}
}
internal void OnInfoMessage(MySqlInfoMessageEventArgs args)
{
if (this.InfoMessage != null)
{
this.InfoMessage(this, args);
}
}
/// <summary>
/// Handles the InfoMessage event of the conn control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="args">The <see cref="T:MySql.Data.MySqlClient.MySqlInfoMessageEventArgs"/> instance containing the event data.</param>
private void conn_InfoMessage (object sender, MySqlInfoMessageEventArgs args) {
//Gets last MySQL error and format it
MySqlError lastError = args.errors[args.errors.Length - 1];
string error = String.Format(
"Error #{0} - {2} [{1}]",
lastError.Code,
lastError.Level,
lastError.Message
);
//Throws an exception to our Error event
if (Error != null) Error(this, new ExceptionEventArgs(new Exception(error)));
}
public virtual List <MySqlError> ReportWarnings(MySqlConnection connection)
{
List <MySqlError> list = new List <MySqlError>();
using (MySqlDataReader mySqlDataReader = new MySqlCommand("SHOW WARNINGS", connection)
{
InternallyCreated = true
}.ExecuteReader())
{
while (mySqlDataReader.Read())
{
list.Add(new MySqlError(mySqlDataReader.GetString(0), mySqlDataReader.GetInt32(1), mySqlDataReader.GetString(2)));
}
}
MySqlInfoMessageEventArgs mySqlInfoMessageEventArgs = new MySqlInfoMessageEventArgs();
mySqlInfoMessageEventArgs.errors = list.ToArray();
if (connection != null)
{
connection.OnInfoMessage(mySqlInfoMessageEventArgs);
}
return(list);
}
public void ReportWarnings()
{
ArrayList arrayList = new ArrayList();
MySqlCommand mySqlCommand = new MySqlCommand("SHOW WARNINGS", this.connection);
MySqlDataReader mySqlDataReader = null;
try
{
mySqlDataReader = mySqlCommand.ExecuteReader();
while (mySqlDataReader.Read())
{
arrayList.Add(new MySqlError(mySqlDataReader.GetString(0), mySqlDataReader.GetInt32(1), mySqlDataReader.GetString(2)));
}
mySqlDataReader.Close();
this.hasWarnings = false;
if (arrayList.Count != 0)
{
MySqlInfoMessageEventArgs mySqlInfoMessageEventArgs = new MySqlInfoMessageEventArgs();
mySqlInfoMessageEventArgs.errors = (MySqlError[])arrayList.ToArray(typeof(MySqlError));
if (this.connection != null)
{
this.connection.OnInfoMessage(mySqlInfoMessageEventArgs);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (mySqlDataReader != null)
{
mySqlDataReader.Close();
}
}
}
internal void OnInfoMessage(MySqlInfoMessageEventArgs args)
{
if (InfoMessage != null)
{
InfoMessage(this, args);
}
}
internal void OnInfoMessage(MySqlInfoMessageEventArgs args)
{
InfoMessage?.Invoke(this, args);
}
public virtual List<MySqlError> ReportWarnings(MySqlConnection connection)
{
List<MySqlError> warnings = new List<MySqlError>();
MySqlCommand cmd = new MySqlCommand("SHOW WARNINGS", connection);
cmd.InternallyCreated = true;
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
warnings.Add(new MySqlError(reader.GetString(0),
reader.GetInt32(1), reader.GetString(2)));
}
}
MySqlInfoMessageEventArgs args = new MySqlInfoMessageEventArgs();
args.errors = warnings.ToArray();
if (connection != null)
connection.OnInfoMessage(args);
return warnings;
}
public void ReportWarnings()
{
ArrayList errors = new ArrayList();
MySqlCommand cmd = new MySqlCommand("SHOW WARNINGS", connection);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
errors.Add(new MySqlError(reader.GetString(0),
reader.GetInt32(1), reader.GetString(2)));
}
hasWarnings = false;
// MySQL resets warnings before each statement, so a batch could indicate
// warnings when there aren't any
if (errors.Count == 0) return;
MySqlInfoMessageEventArgs args = new MySqlInfoMessageEventArgs();
args.errors = (MySqlError[]) errors.ToArray(typeof (MySqlError));
if (connection != null)
connection.OnInfoMessage(args);
}
}
private void conn_info_message(object sender, MySqlInfoMessageEventArgs e)
{
Debug.WriteLine("[Info Message]");
Debug.WriteLine("InfoMesage : {0}", e.errors);
Debug.WriteLine("");
}