Hi

A little example. Your procedure:

CREATE PROCEDURE usp_MyErrorProc

AS

RAISERROR ('Hello, I''m a custom database error.', 11, 1)

In .Net:

private void Button_Click(object sender, RoutedEventArgs e)

{

using (SqlConnection cn = new SqlConnection("Server=(local);Database=Sandbox;Integrated Security=SSPI;"))

{

cn.Open();

using (SqlCommand cmd = new SqlCommand("usp_MyErrorProc", cn))

{

try

{

cmd.CommandType = CommandType.StoredProcedure;

cmd.ExecuteNonQuery();

}

catch (SqlException ex)

{

MessageBox.Show(ex.Message);

}

}

cn.Close();

}

}

Greets

Flo