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 session and cookies?
What are the security types in asp.net?
In SP has contains 10 query,By Using Dataset Object I need to fetch 8th query of records? How?
What are the features of asp net?
Apart from IDE what are the enhancements in asp.net 2.0?
What is a master page and what does it do?
Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
Contrast oop and soa. What are tenets of each16. How does the xmlserializer work? What acl permissions does a process using it require?
How do I create a web form?
Difference between DataView and DataTable
17. If I?m developing an application that must accommodate multiple security levels though secure login and my ASP.NET web application is spanned across three web-servers (using round-robin load balancing) what would be the best approach to maintain login-in state for the users?
What is the difference between HTTP-Post and HTTP-Get ?
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)