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 boxing and unboxing in asp.net?
How can you make sure that web api returns json data only?
How ASP and ASP.NET page works? Explain about asp.net page life cycle?
How can we prevent an aspx page get refreshed when any information fetch from the database ?
What is the difference between pathparam and queryparam?
If I m using Session State Partioning where I have partitioned my session into 4 servers then how can I know that my session will be stored on which server?
About writting a query and SP which is better ?
What is strong-typing versus weak-typing? Which is preferred? Why?
What are the different types of Session state management options available with ASP.NET?
Define WCF ABC , Diffrent Contract. Diff b/w Wcf and in webservice
how to use html code in asp source code?
What are triggers of an updatepanel?
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)