Skip to main content

What is difference between dataset and data reader?

Following are some major differences between dataset and data reader:- Data Reader provides forward-only and read-only access to data, while the Dataset object can hold more than one table (in other words more than one row set) from the same data source as well as the relationships between them. Dataset is a disconnected architecture while data reader is connected architecture. Dataset can persist contents while datareader cannot persist contents, they are forward only. 

Refernce from:-
.NET Interview Questions 4 th Edition By Shivprasad Koirala

Comments

Post a Comment

Popular posts from this blog

Creating Simple Cascading DropDownList In ASP.NET Core MVC With New Tag Helpers

Topic Database part Creating application Installing Package for Entity framework core From NuGet Adding Connection string and Setting up DbContext Adding Category, SubCategory, MainProduct Model in Models Folder Adding DbSet for Category, SubCategory, and MainProduct Model in DatabaseContext class Adding Controller [DemoController] Getting Data from Database using Entity framework core. Adding View [index.cshtml] Binding Category Dropdownlist using new Tag helper Adding SubCategory and Product Dropdownlist to index.cshtml View Adding SubCategory and GetProducts Action Method to Demo Controller Adding Jquery reference on View and Default items in drop-down list Binding SubCategory and Product drop-down list with jquery Ajax Adding Index Action method for handling post request and getting selected values Saving and Run Application Read Entire Article on below link :- http://www.c-sharpcorner.com/article/creating-simple-cascading-dropdownlist-in-asp-net-core-mvc-with-...
Post a Comment
Read more

Capturing Image From Web Cam in ASP.Net MVC

This article shows how to capture an image using a webcam in MVC4 and in this application we will use a jQuery webcam.js plug-in for capturing images. I have seen that most online applications currently require webcam image capturing functionality in some way or another. Most social networking sites use this kind of functionality in their application for capturing user profile pictures. To see Complete Article Visit: -  http://www.c-sharpcorner.com/UploadFile/4d9083/capturing-image-from-web-cam-in-Asp-Net-mvc139/ Agenda Create basic MVC application. Download and Adding webcam.js related reference files to project. Adding Controller ( PhotoController ). Adding Index view. Adding Action Method Capture( ). Adding Script for capturing Image. Adding Action Method and Script for binding image. Adding [HttpPost] Index Action Method. Displaying the index View in New Window. Changephoto.cshtml Code Snippet. PhotoController Code Snippet. Index.cshtml Code ...
Post a Comment
Read more

Spire.Office for .NET

Introduction Free Spire.Doc for .NET is a Community Edition of the Spire.Doc for .NET, which is a totally free word component for commercial and personal use. As a free C#/VB.NET component, it also offers a lot of powerful functions. Developers can use it to generate, read, write, save, print and convert documents on any .NET applications. The featured function, conversion allows converting Word documents (Word 97-2003, Word 2007, Word 2010, word 2013) to commonly used file format, such as XML, RTF, TXT, PDF, XPS, EPUB, HTML and Image etc. Visit Site for Details :-  Click Here to Visit Official Site     Click here to Download Tools :- Download Here In this article we are going to learn how to generate DOC file Use Powerful tool Spire.Office for .NET Tool Required We are using Visual Studio 2012. Free Spire.Office Component [Free for commercial and personal use] Support .Net from [ 2.0 to 4.5 ] Getting Started Let’s start with cre...
Post a Comment
Read more