Validation to Check Duplicate Records

Prevent from inserting duplicate records into the table You need to check if a duplicate entry exists in table before inserting the data. I suggest you could refer to the solution given below: Approach 1=> using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultCSRConnection"].ConnectionString)) { //Open your connection conn.Open(); //Your Select Query ...

Read More »