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 |
Difference between .NET components and COM components?
What are the differences between Dataset and DataReader?
What is different authentication mechanisms used in ASP.NET?
How does viewstate work?
What is actually returned from server to the browser when a browser requests an .aspx file and the file is displayed?
What role “#&&” plays in a querysting?
asp.net interview questions
What is viewstate? In which event of the page life cycle, is the viewstate available?
What is state management in asp.net and define Client-side state management and Server-side state management?
When working with ASP.Net server controls, it is important to use the right event handlers to capture the event for the application to function properly. What event would you use to capture the selection of a new item in a DropDownList control? a) The Click event. b) The SelectionChanged event. c) The SelectionIndexChanged event. d) The ChangedSelection event.
can i call the java script to code behind file?if yes how?
Which color scheme in a Repeater control can you provide alternatively?
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)