what is the deference between dataset and data adapter?
Answers were Sorted based on User's Feedback
Answer / o p yadav
Datasets store a copy of data from the database tables.
However, Datasets can not directly retrieve data from
Databases.
DataAdapters are used to link Databases with DataSets. If we
see diagrammatically,
DataSets < ----- DataAdapters < ----- DataProviders < -----
Databases
| Is This Answer Correct ? | 33 Yes | 2 No |
Answer / sachin gupta
Dataset id used to fetch the data from database in the form row and columns (tables).
Data Adapter is just like meduim or channel through which data is coming from database to dataset
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / satya kumar
dataset is defind copy of the from the it is not directly
connected to the database it connetsd by dataadpter. so
dataadpter is defind the connectin between database and
dataset
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / chakri
Data Adaptor is used for manipulations in database like
select,update and delete and fills the data into dataset
the data accessed by dataadapter is filled in dataset
| Is This Answer Correct ? | 1 Yes | 1 No |
What are the best practices to follow to secure connection strings in an ASP.NET web application?
What is page fragment caching?
How to integrate angular 8 with asp.net mvc 5? : Asp.Net MVC
Explain the use of duration attribute of @outputcache page directive.
Explain code snippet to register exception filters from controller?
What is a page life cycle?
Name two properties common in every validation control?
What is the difference between a session object and cache object
2 Answers CitiGroup, PennyWise,
please can any describe 'Master Page' in ASP.Net 2.0
In which event of the page viewstate is available?
What is postback pixel?
What is the difference between typeof() vs gettype()?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)