How to catch Primary key exception ???

Question

Hi I m faceing problem in catching exception. I m using sqlserver as database. I m takeing User ID as input in textbox for insert query. Now when i press button save. It throws exception related to primary key. It gives message of its own. but i want to give my own message for it. When primary key constraint violates i want to give message ...  USER ID ALREADY EXIST PROVIDE ANOTHER ID. Is it possible ??? How can i do it ? Same way exception handling for open connection & close conection & other database related exception I want to give my own message not .net specific. What can i do??? Please guide me step by step. thank u bhavin gajjar

marcelvojta · Answer

One way how to solve your problem is to use stored procedure with output parameter to insert data. .... define stored procedure with output parameter Create procedure ExampleInsert(@UserIsUnique INTEGER OUTPUT ...) in procedure test if the ID is unique and set the value of parametr UserIsUnique prepare command in C# (SqlCommand myCommand = new SqlCommand InsertUsermyconnection); fill in the parametrs set the property myCommand.UpdateRowSource = UpdateRowSource.OutputParameters; after executing command myCommand.ExecuteNonuery() you can get the value of parameter using this : int ResultOfOperation = (int) myCommand.Parameters[UserIsUnique].Value; (note: if you need other data you can call for example ExecuteReader() method) Bye