Record already exist

Question

hi everyone I am working on windows forms c# visual studio 2013 and sql server 2014 i have a form to enter data for archiving book_no(varchar(20)), book_date(date), department( int ) my question is how to check this book is exist on three fields above when user enters book_no, book_date, department hope my idea is clear any help will be appreciated

Yogesh Ghorpade · Answer

declare @BookNo varchar(10) declare @book_date Date declare @department int if exists (select book_no from Table_Name where book_no=@BookNo and book_date=@book_date and department=@department) begin Select 'Record Is Exists' as Msg Return end else begin Select 'Record Is Not Exists' as Msg Return end

Sanwar Ranwa · Answer

Hello Haider Please check these links https://www.aspsnippets.com/Articles/Check-whether-username-already-exists.aspx https://www.c-sharpcorner.com/UploadFile/f1047f/check-if-usernameemail-already-registered-using-remote-vali/ https://www.c-sharpcorner.com/UploadFile/20abe2/how-to-check-user-name-or-email-availability-using-Asp-Net/

Jenith Thakkar · Answer

Execute this Query select book_no from table where book_no=@book_no and book_date=@book_date and department=@department and store value in one variable then check with this condition like if variable is not null then book exist

Record already exist

Answers (3)