About DataAdapters ?
Answers were Sorted based on User's Feedback
Data Adapters provide in teraction between DataBase and
Dataset.It provite the functionalities like reading the
data from database,update the data,filter the data and wite
the data to Database
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / nitya
DataAdapter acts like a mediator between Dataset and
Datastore(ie.Oracle,Sqlserver or Access).It has two methods
fill() and update().
For Ex:
SqlConnection con=new SqlConnection
("DataSource="databaseEngineName";Initial
Catalog="DataBaseName";User
Id="userName";Password="password";);
DataAdapter da=new DataAdapter(sqlcommand,con);
DataSet ds=new DataSet();
da.fill(ds,"tablename");
da.update(ds);
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / manish singh
DataAdapters is important object of Ado.net. it is used to
transfer data to and from database.
DataAdapter is used to Interact with dataset.
DataAdapter has two method fill() and update().
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kamlesh sharma
DataAdapter acts like a mediator between Dataset and
Datastore
data adpters and datasets are disconnected model
through which we can store data on the local site and we
can perform menupulation on that
| Is This Answer Correct ? | 1 Yes | 0 No |
DataAdapter is the bridge between the dataset and database.
Dataset is the Disconnected architecture,through
dataadapter we can get the data from database to dataset.
Once we get the data from database, connection will be
automatically disconnected.Just like Our mobile set.
Once we connected the charger to our mobile,the mobile will
charged.After batary will charge we will disconnect from
the adapter..like that.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amit bhardwaj
Data Adapter is interface between database and dataset
whatever data is update that is handle by Data Adapter.
| Is This Answer Correct ? | 1 Yes | 0 No |
SqlDataAdapter is a class of ado.net . This class can't be
inherited. It acts as a interface between our aplication
and database. The commonly used method of this class is Fill
() method which is used to fill the DataTable/DataSet with
the data fetched by query from the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sunil
The data adapter we can use with data set.we can use data
adapter when the data is in disconnected form & we have to
apply some oprations on it.the data adapter is in the
tabular form & we can create any no of virtual tables to
fetch data.
| Is This Answer Correct ? | 1 Yes | 4 No |
What is viewstate? What does the "enableviewstate” property do? Whay would I want it on or off?
What is Difference between Callbacks and Postback in ASP.NET?
What is page fragment caching?
Explain diff. Between friend and protected friend?
How will you maintain versioning in asp.net 2.0?
What is the role of global.asax?
What is session handling in a webfarm, how it can work with its limits?
What are merge modules?
What is an Interface and What is an Abstract Class?
What is the difference between excute query and excute nonquery.?
How will u decide when to use caching and when to use viewstate?
What is the page life cycle in asp.net?
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)