CRUD Operations In ASP.NET MVC 5 Using ADO.NET

Sign in to leave a comment.

• V

  vikram1y agoPosted Nov 14, 2024, 11:51 AM

  While running getting error as System.NullReferenceException: 'Object reference not set to an instance of an object.' in addemployee.cshtml.
• 

  Coder Coder3y agoPosted May 30, 2023, 8:03 AM

  You can also my examples
• TC

  Theodore Columbus4y agoPosted Aug 23, 2022, 3:02 PM

  This is a good exercise, except it doesn't work. I created the database in SSMS. When I try to run this I get an error that it can't open the database. Is there anyway to fix this?
• PG

  Peter Galvin4y agoPosted Sep 30, 2021, 9:56 PM

  The downloadable version works, The "tutorial" doesn't.
• PG

  Peter Galvin4y agoPosted Sep 30, 2021, 9:53 PM

  Unable to compile any of this - so many names space declarations not mentioned. Also assemblies not specified. Waste of time.
• 

  Rajesh Thampi5y agoPosted Apr 2, 2021, 8:14 AM

  Thanks Vithal. I remember the times when my seniors asked me to "go to google" as answer for any doubts asked. Today, glad to see that selfless experts like you are sharing so much, so that newbies could learn, adapt and excel. Accept my heartfelt gratitude for the article and the solution. ??
  • PG

    Peter Galvin4y agoPosted Sep 30, 2021, 9:53 PM

    Did it actually build and run?
• JN

  Jonathan Novack6y agoPosted Jun 1, 2020, 8:56 AM

  I'm normally a bit reluctant to use too many stored procedures. They are a bad place to stash too much business logic, harder to debug, and more obscure. Especially those 1,000 line stored procedures. But, for short CRUD-like functionality, it is good stuff. In Java, you can create a Prepared Statement and get as much or more benefit as you do with a db stored procedure, but C# has no way to bypass a lot of built-in overhead inherent in the framework (my biggest bugaboo with the .NET framework - too much unavoidable overhead. This coming from a programmer who has been doing C and assembly on PCs since 1980, bypassing DOS and BIOS and coding directly to metal on the early machines ;) .
• JN

  Jonathan Novack6y agoPosted Jun 1, 2020, 8:37 AM

  Nice to see MVC Controller & View approach. Too many C# programmers are still living in the WebForm/WebPage world with C# embedded in the client pages. I'm a big fan of the .cshtml server-side web-page building to make it a bit harder for anybody who knows how to display source on his browser to gather business information.
• RR

  rajendra rawat6y agoPosted Jan 6, 2020, 1:50 PM

  Good article covering the basic crud features.
  • 

    Vithal Wadje6y agoPosted Jan 9, 2020, 2:23 AM

    Glad to know its helped you
  • PG

    Peter Galvin4y agoPosted Sep 30, 2021, 9:58 PM

    Did you follow the tutorial or did you just download the finished code??
• RS

  Ravi S7y agoPosted May 8, 2019, 5:44 AM

  Where can i add connectionstring.it is not taken any data please help me out
  • AA

    Anonymous Ace7y agoPosted May 14, 2019, 7:42 AM

    Add it to Web.config file. Not in the view folder's web.config. I tried this project it works.
  • RS

    Ravi S7y agoPosted May 14, 2019, 11:45 PM

    I did samething but values are not taking database.
  • 

    Vithal Wadje7y agoPosted Aug 4, 2019, 2:00 PM

    its web.config download sample code
• CT

  CHUAH TEIKWEI7y agoPosted Jan 27, 2019, 9:56 PM

  How to add search , paging , sorting function ?
  • 

    Vithal Wadje7y agoPosted Aug 4, 2019, 2:16 PM

    check my article list you will get it
• 

  Rajashekar K7y agoPosted Jan 20, 2019, 10:00 AM

  "the name 'Html' does not exist in the current context" Error showing in View Page , how to solve this
  • PG

    Peter Galvin4y agoPosted Oct 2, 2021, 11:18 AM

    Check the project references. System.Web.MVC . Examine it properties - CopyLocal needs to be set to True.needs to be set to True.
• 

  Dharmendra Kumar8y agoPosted Oct 4, 2018, 12:57 AM

  Good Article Can you Pls tell me WebApi Article After crud operation?
  • 

    Vithal Wadje7y agoPosted Nov 18, 2018, 9:00 AM

    Check my article list , related to web api
  • 

    Dharmendra Kumar7y agoPosted Sep 26, 2019, 5:59 AM

    Hi Sir there is no article regarding webapi after the crud operation using ado.net both are not so kindly solve my Query
• FM

  Former member8y agoPosted Sep 13, 2018, 4:03 AM

  Hi please help me in writing view details function code to view details of specific employee. Tried to update the code In repository and controllers but unable to get desired result.
  • 

    Vithal Wadje7y agoPosted Nov 18, 2018, 9:00 AM

    Which error are you getting
• 

  Sankeerth Maraganti8y agoPosted Aug 10, 2018, 2:06 AM

  Please help me out how acn we solve this issuse
• 

  Sankeerth Maraganti8y agoPosted Aug 10, 2018, 2:06 AM

  The parameters dictionary contains a null entry for parameter 'Uid' of non-nullable type 'System.Int32' for method 'System.Web.Mvc.ActionResult Edit(Int32)' in 'MongoTracking.Controllers.SkillsController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter.Parameter name: parameters
  • 

    Vithal Wadje7y agoPosted Nov 18, 2018, 9:02 AM

    Check your routing configuration , change optional default id parameter to Uid
• EI

  Eduardo II8y agoPosted Jan 23, 2018, 6:14 AM

  I hope you can create a related article "LogIn Operations In ASP.NET MVC 5 Using ADO.NET" and passing data over different pages or controller via TempData or Session. Thanks...
  • 

    Vithal Wadje7y agoPosted Nov 18, 2018, 9:03 AM

    Will prepare soon & post you a link
• NS

  Nooh shaikh9y agoPosted Jul 10, 2017, 9:09 AM

  Plz give me solution
• NS

  Nooh shaikh9y agoPosted Jul 10, 2017, 9:08 AM

  (This type of error coming) An exception of type 'System.NullReferenceException' occurred in CRUD Using MVC WithAdoDotNet.dll but was not handled in user code
  • 

    Vithal Wadje7y agoPosted Nov 18, 2018, 9:06 AM

    Have you changed connection details as per your server details
• 

  Avinash Thakur9y agoPosted Apr 28, 2017, 1:34 AM

  Nice Article sir;)
• ZB

  Zaheer Beg9y agoPosted Jan 21, 2017, 4:38 AM

  Thanks Sir..Nice and Simple 4 Beginner...Keep Uploading...
• S

  saich9y agoPosted Oct 28, 2016, 11:14 AM

  Hello, in the above example is ID column an identity column? thanks
  • 

    Vithal Wadje7y agoPosted Nov 18, 2018, 9:06 AM

    Yes that's right
• 

  Vithal Wadje10y agoPosted Feb 7, 2016, 9:16 AM

  Thanks Shubham sir
• 

  Vithal Wadje10y agoPosted Feb 7, 2016, 9:16 AM

  EL refer my other articles
• 

  Shubham Kumar10y agoPosted Feb 6, 2016, 6:11 AM

  nice sir
• EW

  El Not To Worry10y agoPosted Nov 5, 2015, 9:20 AM

  Would you have an example, using same concept on how to bind a dropdownlistfor
• 

  Vithal Wadje11y agoPosted Sep 14, 2015, 11:41 AM

  Thanks sir
• 

  ROHAN THAKUR11y agoPosted Sep 14, 2015, 7:33 AM

  gud one sir ji...
• 

  Vithal Wadje11y agoPosted Sep 8, 2015, 2:39 PM

  yes Pc Patel sir there are many more option to avoid heavy entity framework wait for my future articles
• 

  Phoolchand Patel11y agoPosted Sep 8, 2015, 7:18 AM

  Very good article Vithal sir, this will help a lot to who don't want to choose entity framework.
• 

  Vithal Wadje11y agoPosted Sep 7, 2015, 11:49 AM

  Thanks Shridhar Sharma sir
• 

  Vithal Wadje11y agoPosted Sep 7, 2015, 11:48 AM

  Thanks Debasis Saha sir
• 

  Vithal Wadje11y agoPosted Sep 7, 2015, 11:47 AM

  Thanks Amol Jadhao sir
• 

  Shridhar Sharma11y agoPosted Sep 7, 2015, 11:03 AM

  very nice article Vithal sir. Thanks for sharing.
• 

  Debasis Saha11y agoPosted Sep 7, 2015, 9:42 AM

  Good One..
• 

  Amol Jadhao11y agoPosted Sep 7, 2015, 5:35 AM

  Great...!!!
• 

  Vithal Wadje11y agoPosted Sep 7, 2015, 4:10 AM

  Thanks Abhishek Singh sir
• 

  Abhishek Kumar11y agoPosted Sep 7, 2015, 3:38 AM

  Very nicely explained ..Thanks for sharing Vithal ..
• 

  Vithal Wadje11y agoPosted Sep 7, 2015, 12:52 AM

  Thanks Rahul Saxena sir
• 

  Rahul Kumar Saxena11y agoPosted Sep 7, 2015, 12:24 AM

  Good one
• 

  Vithal Wadje11y agoPosted Sep 6, 2015, 2:57 PM

  Thanks Rakesh Chavda sir
• 

  Rakesh11y agoPosted Sep 6, 2015, 2:08 PM

  Good Explain Sir
• 

  Vithal Wadje11y agoPosted Sep 6, 2015, 1:52 PM

  Thanks Santhakumar Munuswamy sir
• 

  Vithal Wadje11y agoPosted Sep 6, 2015, 1:52 PM

  Thanks Karthikeyan K sir
• 

  Vithal Wadje11y agoPosted Sep 6, 2015, 1:52 PM

  Thanks Rajeesh Menoth sir
• 

  Vithal Wadje11y agoPosted Sep 6, 2015, 1:51 PM

  Thanks Shubham Kumar sir
• 

  Vithal Wadje11y agoPosted Sep 6, 2015, 1:51 PM

  Thanks Pankaj Kumar Choudhary sir
• 

  Santhakumar Munuswamy11y agoPosted Sep 6, 2015, 1:07 PM

  Good one. Thanks for sharing
• 

  Karthikeyan K11y agoPosted Sep 6, 2015, 12:52 PM

  Awesome sir...Thanks for sharing :)
• 

  Rajeesh Menoth11y agoPosted Sep 6, 2015, 12:17 PM

  Great..Good One
• 

  Shubham Kumar11y agoPosted Sep 6, 2015, 11:48 AM

  Thank you sir
• 

  Pankaj Kumar Choudhary11y agoPosted Sep 6, 2015, 11:23 AM

  Nice Explain Sir............