To read more dot net interview questions or any interview questions visit InterviewQsn.com
ADO.NET come from its previous version that is ADO. It is disconnected and ADO is connected on the other hand. Locking can also be done in ADO.NET and in it all the data can be map with the XML and One of most significance feature of ADO.NET is DataProvider.
This data provider can access diffreent data just like SQL, Oracle, Access and do some beautifull task like update, delete, insert and manage database. it provides object to achieve functionalities like opening and closing connection, retrieve data, update data and many more.There are the four main sections of a data provider.
(1) Connection.
(2) Command object
(3) Data Adapter
(4) Datareader
Datareader and Dataset are the two fundamental objects in ADO.NET. DataReader provides forward-only and read-only access to data on the other side. Dataset is a disconnected architecture while datareader is connected architecture.
There are some of data provider ADO.NET namespace:-
System.data :-Its contains objects that are used to access and store relational data example DataSet,DataTable, and DataRelation. Each of these is independent of the type of data source and the way we connect to it.
System.Data.OleDB:-Its contain objects that are for connecting to a data source with the help of OLE-DB provider, example OleDbConnection, OleDbCommand, etc. These objects comes from the common base classes and same properties, methods, and events as the SqlClient equivalents.
System.Data.SqlClient:-Its contains the objects that are used to connect to a data source TDS interface of Microsoft SQLServer.
System.XML:-Last but most important these day is System.XML its Contains the basic objects required to create, read, store, write, and manipulate XML documents according to W3C recommendations.
Note:-
(1)OleDbConnection object is used with an OLE-DB provider
(2)SqlConnection object uses Tabular Data Services (TDS) with MS SQL Server
(3)System.Data.SqlClient is used for the sql database on the other hand System.Data.Oledb is used for data base that are in Access,Excel etc.
- Related Videos
- Related Articles
- Ask / Related Q&A




Illegal Interview Questions: How to Respond to Illegal Questions
By: Andrea | 08/11/2009The law prohibits discrimination on the basis of age, sex, race, origin and religion. One would hope that the vast majority of interviewers know which questions not to ask, but you never know what to expect so it's always a good idea to be ready for any questions that probe your personal life.
Firefighter Oral Board Interview
By: Brandon | 08/11/2009Pass your next Firefighter Interview
You Must Adapt Your Job Search To The Company's Culture and Style
By: Brad Remillard | 07/11/2009Our job search coaching and facilitation programs for candidates take us down many different paths. Every program has to be unique to the needs of the candidate. No two job searches are alike and there is never a one-size-fits-all approach to a job search. Customizing our coaching programs is the hallmark of our success. One example of this happened towards the end of the process with one of our sales and marketing executives.
There is No Time for On The Job Training While in a Job Search
By: Brad Remillard | 07/11/2009A job search is much like a cable news show, you have to get your point across in sound bites. You often don't have time to give a detailed answer. Candidates need to get comfortable with doing this.
Are You Speaking the Right Language During the Interview?
By: Brad Remillard | 07/11/2009Candidates too often focus exclusively on the verbal communication aspects of a job search. How much time have you spent on the body language aspect of communications?
Placement Papers a need to get a good job
By: Asif Khan | 07/11/2009Placement Papers does a very important role to get right job in right company. Companies Placement Papers and exam papers gives an exact idea about the knowledge of the student who is Appling for the job.
Tips To Get Dream Fresher Jobs in India
By: Asif Khan | 07/11/2009Fresher Jobs i s a big job industry in india where everyone looks for big brand companies.Every gradaute student look for a fresher jobs after college.
Web Camera Job Interviews and Cost Effective Recruiting
By: Shaun Hummel | 06/11/2009Web conferencing is available FREE of charge allowing recruiters to interview candidates from their office and setting up video interviews between their distant clients and candidates at the recruiter office. Some recruiters often have to interview candidates for 10 minutes at their office before approving resume submittal and clients of course want to do personal interviews unless it is a contract. Having the option to offer personal interviews is a selling point.
Interview Tips or Guides on ADO dot Net
By: Adam Sturo | 10/06/2009 | InterviewsThe given article explains topic names Ado dot net which helps you in gaining brief knowledge about the same.
Women’s Study – necessary or not
By: Adam Sturo | 24/03/2009 | College & UniversityFew are aware of the unique history of women’s studies in India, which emerged in the 1970s and early 1980s, during years of political and social turmoil. A founding generation of teachers, students, young women in the IAS, and
About AUW - Asian University for Women - faq
By: Adam Sturo | 20/03/2009 | College & Universitythis article tells you about top and best colleges in india and frequently asked question about asian university for women.
Colleges And Universities In India – Think About Your Career
By: Adam Sturo | 18/03/2009 | College & UniversityRaffles Education Corporation, in Partnership With Educomp Solutions Ltd, Has Opened Its Design Institute Raffles Millennium International (rmi) in New Delhi at Pusa Road. the Chief Guest for the
C# Dot Net And Vb Dot Net
By: Adam Sturo | 06/03/2009 | InterviewsWhen we use asp.net we have different language option available there are some of these language vb.net , c# dot net, perl etc.So its depend upon the programmer which language
Top and Best Colleges in India - Acharya Institute, Sha-shib Group
By: Adam Sturo | 28/09/2008 | College & UniversityThis article provides you the list of colleges (engineering, architecture, mba, dental, medical, ayurvedic colleges, law, fashion design colleges) and universities in india
Are You Looking for Brides or Grooms - Stop Your Search
By: Adam Sturo | 12/05/2008 | MarriageThis article provides you the listing of brides and grooms in india, us, uk, canada and pakistan. Have a look on these brides and grooms and select any one you want to marry with.
Yoga Education – Additional Study With Your Education
By: Adam Sturo | 12/05/2008 | CareersThis article tells about the yoga education with normal study. It is an important study for your children.