Check dublicate from inSQL while inserting Data from UI C#

Question

Check dublicate from inSQL-DB while inserting Data from UI in C#. Consider two textbox as -EMP-CODE and NAME... i want insert somethink to SQL_DB. but while inserting it should check dublicate data in DB. If dublicate exist it wont allow to insert in DB. Giving a msg..dublicate data not allowed....??? pls help

Delpin Susai Raj · Answer

http://www.aspforums.net/Threads/149003/How-to-avoid-duplicate-record-inserts-in-SQL-Server-using-C-and-ASPNet/

Esakki Muthu · Answer

Hi Matt Assign unique key constraint to those columns in DB.Then 1)If u r using entity framework  then u can simply write LINQ query to verify whether the same employee is already exist  if exist then rerun some alert to the UI. 2) If you are not using EF then write a SP to check whether that employee is already exists or not. LINQ var emp = _dbContext.employeetable.where(e=>e.code == yourinputempcode && e.name == yourempname).select (e=>e).FirtOrDefualt();

Bikesh Srivastava · Answer

You need to check user from database . follow this link. http://www.c-sharpcorner.com/article/remote-validation-in-mvc-5-to-check-if-username-and-email-id-exists/