DataReader:
Datareader is like a forward only recordset. It fetches one row at a time so very less Network Cost compare to DataSet(Fetches all the rows at a time). DataReader is readonly so we cannot do any transaction on them. DataReader will be the best choice where we need to show the data to the user which requires no transaction i.e reports. Due to DataReader is forward only we cannot fetch the data randomly. .NET Dataproviders optimizes the datareaders to handle the huge amount of data.
DataSet:
DataSet is always a bulky object that requires lot of memory space compare to DataReader. We can say the dataset as a small database because it stores the schema and data in the application memory area. DataSet fetches all data from the datasource at a time to its memory area. So we can traverse through the object to get required data like querying database.The dataset maintains the relationships among the datatables insideit. We can manipulate the realational data as XML using dataset.We can do transactions (insert/update/delete) on them and finally the modifications can be updated to the actual database. This provides impressive flexibility to the application but with the cost of memory space. DataSet maintains the original data and the modified data seperately which requires more memory space. If the amount of data in the dataset is huge then it will reduce the applications performance dramatically.
Posted Date:- 2021-09-21 05:14:55
What Is The Advantage Of Option Strict On?
What Is The Diff Between Vb Mdi Form And .net Mdi Form?
How Would You Implement Inheritance Using Vb.net ?
How To Check For A Particular Record Whether It Is Present Or Not In Dataset
How To Store And Retrieve Images In Sql Server Database Through Vb.net?
Differences Between Vb.net And C#, Related To Oops Concepts?
How Can I Extract The Formated Word(bold,italic,underline,font,color Etc) From The Msword File.?
Whats The Difference Bt. .dll Extension And .exe Extension Files?
What Is The Base Class Of .net?
Please List Some Final Year Projects That Can Be Done Using Vb.net In The Application Level.
What Is The Dif B/w Panel And Groupbox.
What Is The Difference B/w Readonly Variable And Constant Variable?
How To Call A List Box On The Text If Some One Send Me The Code For It
What Are Fixed Memory Leaks And Threads Locking Problems.
What Is The Common Language Runtime?
Is There Any Easy Way To Convert Vb6 Programs To Vb.net?
What Are The Similarities Between Class And Structure?
What Is The Difference Between Clr & Cts?
What Is The Difference Between Friend And Protected Friend?
How Do You Declare Static Variable And How It Is Declared And What Is Its Lifetime?
What Is The Difference Between Dataset And Datareader?
How Does You Get Record No From 5 To 15 From A Dataset Of 100 Records?
What is the difference between value and reference types?
What do you understand by the term Code Security?
What is the purpose of the Async keyword in VB.NET?
Describe what Authentication and Authorization means? What are the types of Authentication?
What are Option Strict and Option Explicit?
Briefly explain about the different types of threading models n Vb.net?
Illustrate the differences between a dataset and recordset?
Briefly explain about the terms meta data and JIT?
Explain the dialog boxes used in the Windows form of Vb.Net?
What are the main differences between functions and subroutines?
What is the object-oriented programming approach in the .net framework?
What are the shared variables in Vb.Net?
Explain the meaning of delegate in .NET?
What is garbage collection in the context of vb.net?
What are the types of Authentication?
What is Authentication and Authorization?
What is the difference between System.String and System.StringBuilder classes?