what is data Adapter?
Answers were Sorted based on User's Feedback
Answer / beginner
In the Disconnected Database architecture we have two databases.
1. the actual one on the server.
2. the consisting of tables, that we have takenin our
dataset and manipulated the data.
both are in two different states...
Data adaptor is responsible to sync this two whenever a
realtime connection is established between these two...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pankaj
DATA ADAPTER IS BRIDGE BETWEEN DATA SOURCE AND DATASET.
WE CAN SAY ALSO
IT IS COLLECTION OF COMMANDS
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / velmani
DataAdapter is used to Retrieves the data from a Data base
and fill the DataSet..
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anujchaudhary
The DataAdapter can perform Select , Insert , Update and Delete SQL operations in the Data Source. The Insert , Update and Delete SQL operations , we are using the continuation of the Select command perform by the DataAdapter. That is the DataAdapter uses the Select statements to fill a DataSet and use the other three SQL commands (Insert, Update, delete) to transmit changes back to the Database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain advantages of ado.net?
What are the different ado.net namespaces are available in .net?
Difference between function and trigger?
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
Define data access layer?
What is datasource in ado.net?
What is ambient transaction?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.
2 Answers Fulcrum Logic, Satyam,
What are all the different authentication techniques used to connect to MS SQL Server?
How is entity framework different from ado.net?
Which is faster dataset or datareader?
Call a stored procedure from ado.net and pass parameter to it ?
7 Answers Keane India Ltd, TCS,
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)