describe about the ado.net object model
Answers were Sorted based on User's Feedback
Answer / priya
ADO object model includes five components.
They are:
SqlConnection Object,SqlCommand Object,SqlDataReader
object,Dataset object,SqlDataAdapter object.
| Is This Answer Correct ? | 26 Yes | 2 No |
Answer / prakash
Not Sql ADO Object Model Only.But ADO.Net has the following
methods also
1.OLEDBProvider
2.SQLProvider
3.ODBCProvider
the above all has the Connection,Command,Data Reader, Data
Set, Data Adapter Also.So Finally List Only Common Object
Models , They are
1. Connection Objects
2. Command Objects
3. DataReader Object
4. DataSet Object
5. DataAdapter Object
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / sandyni
The main object model of an ADO.Net architecture is "Data
Provider". It provides data access to SQl server ,Oracle,
Access in order to retreive,update and insert data in the
datastore.
the main objects of ADO.Net object model are....
1.connection object : used to establish connection to
database.
2.command object: it is used to execute commands and stored
procedures.
3.dataAdapter object: used to establish connection between
datastore and dataset.
4.dataReader object: used to read data from dataset in
forward only.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / michael jerold
connection object
command object
dataadapter object
datareader object
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the advantages of oledb compared with other classes?
What is basic use of data view?
What is a control toolbox?
What is the default provider in ado.net?
What does sqldatareader return?
How do you sort the data in datagrid?
What two types of data providers does ADO.NET supply? What determines which one you should use?
How would u connect to database using .NET?
What is the difference between executenonquery () and executescalar ()?
What is shadow copy?
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
How to bind the controls(best practice) comboboxes to the data in the dataset?
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)