WHAT Are the major major compnents of a data provider in
ADO.net.
Answers were Sorted based on User's Feedback
Answer / niti
Major components of data provider in ADO.net indlude:
SQLDataProvider
OLEDBDataProvider
ODBCDataProvider
Various objects of the data provider include:
Connection object,
Command object,
Data Adapter,
Data Set,
Data Table
Is This Answer Correct ? | 17 Yes | 1 No |
Answer / puneet sharma
....dataadapter is the major comp of dataprovider
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ranjeet kumar panda
.NET Framework data provider, which is a set of components:
Connection objects,
Command objects,
DataReader objects,
DataAdapter objects
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / tejas mer
DataAdapter and DataSet are major parts of ADO.NET
DataReader is connected architecture and it's read-only, forward only type, so when you just want to display the data better to use it, it consumes less memory with compare to dataset as well.
DataSet is we can say in-memory representation of the data.
It's disconnected architecture.
Contains DataTables, which are further divided into Datarows and Datacolumns.
Also contains DataRelationships and Contraints...
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / tubax
command object
connection object
datareader
dataset
dataadapter
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sanjogita
The two major components of data provider are:-
1)command
2)connection
3)data reader
4)data adapter
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nivedita
components are
command
connection
reader
adopter
Is This Answer Correct ? | 0 Yes | 0 No |
Why is it important to close an ado.net application?
What are the important features of ado.net 2.0?
How we can provide data to ado.net?
OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it
What is ado.net connection?
What is csdl entity framework?
If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?
I am fresh graduate, trained in C# .net. How do i answer when interview ask me , Where do you see yourself within 5 years from now?
How to check if a datareader is closed or opened? IsClosed()
What are ado.net objects?
Explain the differences between oledb sql server, oledbdotnet provider?
What is a data control clerk?