Question { IBM, 28642 }

What?s the difference between Response.Write()
andResponse.Output.Write()?

Answer

Response.write - it writes the text stream
Response.output.write - it writes the HTTP Output Stream.

They are used to display output text in formatted manner as
below
Response.Write() output fotmat :
Response.Write"

" & iTimer & "

"
Response.Output.Write() output format :
Response.Output.Write("

Process running as {0}

",
WindowsIdentity.GetCurrent().Name);

Question { 7762 }

What is the difference between Server.Transfer and
Response.Redirect?

Answer

Server Transfer simply tranfer execution to another page .
This doesnt require any information to be sent to the
browser that is it all occors on the server without the
users knowledge, doesnt update the client's URL history
list or current url
Response Redirect method sends HTTP information to the
browser instructing it to go to another page perform round
trip back to the client when the client's browser is
redirected to the new page.The user's browser history list
is updated to reflect the new address.

Question { Wipro, 9836 }

Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?

Answer

1. In ADO recordset(in memory representation of data) looks
like single table
where as
in ADO.NET dataset(in-memory representation of data) is a
collection of one or more tables(use JOIN Query).
2. In ADO you communicate with the database by making the
calls to an OLEDB Provider
where as
in ADO.NET you communicate with the database through a Data
Adapter(an OledbDataAdapter,SQLDataAdapter,OdbcDataAdapter
or OracleDataAdapter object) which make calls to an OLEDB
Provider or the API's provided by the underlying datasource.
3. In ADO recordset objects operate in a fully connected
state
where as
in ADO.NET dataset operate in disconnected state.
4. ADO requires COM marshalling to transmit records sets
among components, does require that ADO data types be
converted to COM data types.
where as
ADO.NET does not require data-type conversions.
5. In ADO it is sometime sproblematic firewalls( firewalls
are typically configured to allow HTML text to pass, but to
prevent system-level requests (such as COM marshalling)
from passing) prevent many types of requets
where as
in ADO.NET datasets using XML, firewalls can allow datasets
to pass.

Question { HCL, 19311 }

What is dataset and uses of dataset ?

Answer

DATASET:
The dataset is a in-memory representation of data.
DataSet is made up of a collection of DataTable objects.
It can be considered as a local copy of the relevant
portions of the database.
The data is persisted in memory and the data in it can be
manipulated and updated independent of the database. When
the use of this dataset is finished, changes can made back
to the central database for updating.
The data in dataset can be loaded from any valid
datasources like Microsoft SQL Server database, an Oracle
database or a Microsoft Access database.
USES:
1. You normally use datasets to hold results of database
queries, but you can also create them on the fly and
populate them programmatically.
2. The DataSet object has characteristics that make it
suitable for persisting application settings: It can hold
hierarchical data in the Tables collection, and you can use
the WriteXml() method to save the entire dataset into an
XML file with a simple call:

ds.WriteXml(strFileName,
XmlWriteMode.WriteSchema);
3. We can seperate data layer from presentation layer by
using class or dataset in .net 2.0.
4. The DataSet in .Net rocks, it provides so much
functionality for free, that it makes it the prefered data
transport mechanism between the presentation layer and the
buisiness layer, when dealing with a pure .Net technology
stack then DataSet's are the way to go.
5. DataSet has some powerful XML-related capabilities. For
example, you can serialize a DataSet into XML through its
WriteXml() method; conversely, you can populate a DataSet
from a properly formatted XML stream using the DataSet's
ReadXml() method.