1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
public void RaiseMe()
{
SqlConnection _cn = new SqlConnection();
_cn.ConnectionString="ta connection string"
_cn.Open();
_cn.InfoMessage += new SqlInfoMessageEventHandler(_cn_InfoMessage);
var cmd = _cn.CreateCommand();
//Message
cmd.CommandType = CommandType.Text;
cmd.CommandText="RAISERROR(N'Un message', 10,1)";
var cmd2 = _cn.CreateCommand();
//Exception
cmd2.CommandType = CommandType.Text;
cmd2.CommandText = "RAISERROR(13000,10,255)";
try
{
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
}
catch (SqlException ex)
{
//http://msdn.microsoft.com/en-us/library/ms178592.aspx
}//pour 1 :Is an integer from 0 through 255. Negative values or values larger than 255 generate an error.
//pour 10 : Severity levels from 0 through 18 can be specified by any user. Severity levels from 19 through 25 can only be specified by members of the sysadmin fixed server role or users with ALTER TRACE permissions. For severity levels from 19 through 25, the WITH LOG option is required.
}
void _cn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
//C'est là qu'arrive le message!
} |
Partager