How to catch Primary key exception ???

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 "InsertUser",myconnection); 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