private void Con_InfoMessage(object sender, SqlInfoMessageEventArgs s)
{
//this.m_MainClass.m_SysLogClass.SystemLog(this, s.Message);
}
/// <summary>
/// The sql connection_ info message.
/// </summary>
/// <param name="sender">
/// The sender.
/// </param>
/// <param name="e">
/// The e.
/// </param>
private void sqlConnection_InfoMessage([NotNull] object sender, [NotNull] SqlInfoMessageEventArgs e)
{
this._sqlMessages.Add(e);
}
/// <summary>
/// Обработчик событий о получении с сервера БД
/// </summary>
/// <param name="sender">Ссылка на объект</param>
/// <param name="e">Аргумент сообщения сервера</param>
private void Connection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
Configuration_class.connection.InfoMessage -= Connection_InfoMessage;
}
private void _context_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
OnInfoMessage(sender, e);
}
static void conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
Console.Write(e.Message);
}
private void Cn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
this.lblMensaje.Text = e.Message;
}
private void SqlInfoMessageEventHandler(object sender, SqlInfoMessageEventArgs e)
{
WriteInformation(messageData: e, tags: null);
}
////Liên quan đến số lượng
//public int ExecuteNonQuery(string query, object[] parameter = null)
//{
// int data = 0;
// using (SqlConnection connection = new SqlConnection(connectionSTR))
// {
// connection.Open();
// SqlCommand command = new SqlCommand(query, connection);
// if (parameter != null)
// {
// string[] listPara = query.Split(' ');
// int i = 0;
// foreach (string item in listPara)
// {
// if (item.Contains('@'))
// {
// command.Parameters.AddWithValue(item, parameter[i]);
// i++;
// }
// }
// }
// data = command.ExecuteNonQuery();
// connection.Close();
// }
// return data;
//}
//public object ExecuteSchalar(string query, object[] parameter = null)
//{
// object data = 0;
// using (SqlConnection connection = new SqlConnection(connectionSTR))
// {
// connection.Open();
// SqlCommand command = new SqlCommand(query, connection);
// if (parameter != null)
// {
// string[] listPara = query.Split(' ');
// int i = 0;
// foreach (string item in listPara)
// {
// if (item.Contains('@'))
// {
// command.Parameters.AddWithValue(item, parameter[i]);
// i++;
// }
// }
// }
// data = command.ExecuteScalar();
// connection.Close();
// }
// return data;
//}
//#endregion
public void InfoMessageHandler(object sender, SqlInfoMessageEventArgs e)
{
MessageBox.Show(e.Message);
}
void myConnection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
err = e.Message;
}
// EVENTO trae los PRINT de SQL Server
static void InfoMessageHandler(object sender, SqlInfoMessageEventArgs e)
{
mensajeBean.mensaje += e.Message + "\n";
}
public void MessageInformation(object sender, SqlInfoMessageEventArgs e) //Сообщение об ошибке
{
MessageBox.Show(e.Message);
}
static void connection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
File.AppendAllText(logFile, e.Message + Environment.NewLine);
}
/// <summary>
/// SQL 서버로부터 경고나 정보메시지가 리턴될 때
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SqlConnection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
lbxResult.Items.Add(e.Message);
}
void OnConnInfo(object sender, SqlInfoMessageEventArgs e)
{
throw new NotImplementedException();
}
private void SqlConnection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
_logger?.LogInformation(e.Message);
}
private void Conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
MessageBox.Show(e.Message);
}
private void message(object sender, SqlInfoMessageEventArgs e)
{
Registry_Class.error_message += "\n" + DateTime.Now.ToLongDateString() + " " + e.Message;
}
private static void Connection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
Console.WriteLine(e.Message);
}
/// <summary>
/// Extends BeginInvoke so that when a state object is not needed, null does not need to be passed.
/// <example>
/// sqlinfomessageeventhandler.BeginInvoke(sender, e, callback);
/// </example>
/// </summary>
public static IAsyncResult BeginInvoke(this SqlInfoMessageEventHandler sqlinfomessageeventhandler, Object sender, SqlInfoMessageEventArgs e, AsyncCallback callback)
{
if (sqlinfomessageeventhandler == null)
{
throw new ArgumentNullException("sqlinfomessageeventhandler");
}
return(sqlinfomessageeventhandler.BeginInvoke(sender, e, callback, null));
}
/// <summary>
/// The connection information message collection method.
/// </summary>
/// <param name = "sender">The sender.</param>
/// <param name = "e">The events for the message.</param>
private void ConnectionInfoMessage(object sender, SqlInfoMessageEventArgs e)
{
Messages += e.Message + Environment.NewLine;
}
static void conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
MessageBox.Show("Lỗi: " +
e.Errors[0].Class.ToString() + ":" + e.Message);
}
private static void ConnectionOnInfoMessage(ICollection <TableRow> infoMessageRows, SqlInfoMessageEventArgs sqlInfoMessageEventArgs)
{
if (infoMessageRows == null)
{
throw new ArgumentNullException(nameof(infoMessageRows));
}
if (sqlInfoMessageEventArgs == null)
{
throw new ArgumentNullException(nameof(sqlInfoMessageEventArgs));
}
foreach (SqlError error in sqlInfoMessageEventArgs.Errors)
{
if (error.Class >= 11)
{
Logger.Error($"Class {error.Class} message type {error.Number} from line {error.LineNumber}. See information messages.");
}
var items = new object[6];
items[0] = error.Class;
items[1] = error.Number;
items[2] = error.State;
items[3] = error.Procedure;
items[4] = error.LineNumber;
items[5] = error.Message;
var row = new TableRow(items);
infoMessageRows.Add(row);
}
}
public virtual void OnInfoMessage(object sender, SqlInfoMessageEventArgs e) { }
private void conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
strRunMessage = e.Message;
}
static void connection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
// this gets the print statements (maybe the error statements?)
var outputFromStoredProcedure = e.Message;
var outputFromStoredProcedureE = e.Source;
}
public void OnSqlConnectionInfoMessage(object sender, SqlInfoMessageEventArgs eventArgs)
{
string c = eventArgs.Message.ToString();
MessageBox.Show(c, "Информация для пользователя", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void SqlCon_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
this.Mensaje_respuesta = e.Message;
}
protected void myConnection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + e.Message + "');", true);
Response.Write(e.Message);
}
/// <summary>
/// Réception d'un message de la part du serveur SQL.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void con_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
rtb_log.Text += e.Message + "\n";
rtb_log.Refresh();
}
void Connection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
_sqlInfoMessages.Add(e);
}
