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.

Check record already exists in mvc

Home
Forums
Learn iOS Programming

Check record already exists in mvc

6yAsked Feb 19, 2020, 12:38 AM735Learn iOS Programming

Hello everyone.

How to check record already exists in database and update data then record does not exists.

1 Reply

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

Laxmidhar Sahoo6y ago
1. int id = 50;
3. using (WebApplication1Entities db = new WebApplication1Entities())
4. {
5. var order = db.Cars.GetAll().Where(x=> x.Car_id == id).FirstOrDefault();
6. if(order != null) // update
7. {
8. //.....
9. db.SaveChanges();
10. }
11. else
12. {
13. // save
14. }
15. }
17. //For database ado.net
19. string s = @"SELECT COUNT(*) FROM Cars WHERE Car_id = @Car_id))";
20. sCommand = new SqlCommand(s, con);
21. sCommand.Parameters.AddWithValue("@Car_id", txt_Car_id.Text);
22. con.Open();
23. int records = (int)sCommand.ExecuteScalar();
25. if(records == 0)
26. {
27. //new record entry
28. }
29. else
30. {
31. Response.Write("Records Exists");
32. }