Articles → ADO.NET → Catch Primary Key Violation Exception In Ado.Net

Catch Primary Key Violation Exception In Ado.Net

Software Requirement

1. Visual studio (any version) is installed on your machine.
2. SQL server (any version) is installed on your machine.

Prerequisite Knowledge

1. Basics about ado.net.
2. Basics about SQL server.
3. How to create a project using visual studio?
4. Basics about asp.net controls.
5. Exception handling in .net.

Steps Of Execution

1. Create a new project
2. Create a new table
3. Add controls to the page
4. Add code to handle primary key violation exception.

Create A New Project

Create A New Table

Add Controls To The Page

Add Code To Handle Primary Key Violation Exception

try {
	string connectionstring = @"your_connection_string";
	using(SqlConnection connection = new SqlConnection(connectionstring)) {
		connection.Open();
		string query = string.Format("insert into Employee values('{0}','{1}')", txtEmailId.Text, txtFullName.Text);
		using(SqlCommand command = new SqlCommand(query, connection)) {
			command.ExecuteNonQuery();
		}
	}
}
catch(SqlException ex) {
	if (ex.Number == 2627) {
		Response.Write("This is the primary key violation");
		return;
	}
	else {
		Response.Write("This is the general error");
		return;
	}
}

Code Explanation

Output