Ado.net Interview question answer.
Difference between ADO and ADO.Net ?
| ADO has the recordset and connected archtecture where as |
ADO.net has disconnected archtecture and DATASET |
| ADO used OLE DB to access data and is COM-based |
ADO.net uses XML as the format |
| ADO has one main object that is used to reference data, called the Recordset object. This object basically gives you a single table view of your data |
With ADO.NET, you have various objects that allow you to access data in various ways. The DataSet object will actually allow you to store the relational model of your database |
What are the attirbutes of DataSet?
DataSet
DataTabel
DataColumns
Datarow
DataPrimaryKey
DataForgeinKey
DataRelationship
What is magic table?
When we create a table in sql, at the same time two
tables(Insert table, Delete Table) are created automatically
at the backend. It is Magic Table
we can't able view that table...
How to merge 2 dataset ?
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
ds1.Merge(ds2,true);
How to fill dataset ?
DataSet ds1 = new DataSet();
SqlDataAdapter objDA = new SqlDataAdapter("Select * from Mytable1", "connectionstring");
objDA.Fill(ds1);
Here we must remember we also can fill a datatable instead of dataset directly from adaptor. i mean
DataTable dt1 = new DataTable();
SqlDataAdapter objDA = new SqlDataAdapter("Select * from Mytable1", "connectionstring");
objDA.Fill(dt1);
See Dataset pagging
What is connection pulling in .net?