Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Record already exist

Home
Forums
Windows Forms

Record already exist

Haider Jaafer

8yAsked Aug 20, 2018, 2:21 AM1.1kWindows Forms

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Yogesh Ghorpade8y ago
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 Ranwa8y ago
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 Thakkar8y ago
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