| Back to Questions Page |
| |
| Question |
WHAT Are the major major compnents of a data provider in
ADO.net. |
Rank |
Answer Posted By |
|
Question Submitted By :: Tejas-11 |
| This Interview Question Asked @ Wipro , Infosys |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | data adaper  |
| Hemnath.c |
| |
| |
| Answer | Data Adapter  |
| Guest |
| |
| |
| Answer | Dataset and .Net data provider  |
| Rajeesh M |
| |
| |
|
|
| |
| Question |
Which is the best institute in navi mumbai to learn DotNet |
Rank |
Answer Posted By |
|
Question Submitted By :: Sunildeo6 |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Ambrish Kirkire Institute...
Sector 15
Contact Number:9820761200  |
| Narayan Swami |
| |
| |
| Question |
What is Pooling? what is data pooling? what is sql pooling? |
Rank |
Answer Posted By |
|
Question Submitted By :: Muralisivam |
| This Interview Question Asked @ TCS |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | through pooling we use a same connection or create new
connection.  |
| Sagar Shinde |
| |
| |
| Question |
Execute nonquery returns no. of afected rows.So if my stored
procedure hav lot of select stmnt, delete stmnt, insert
stmnt..then what does execute nonquery returns in this case? |
Rank |
Answer Posted By |
|
Question Submitted By :: Divyaanumod |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Execute nonquery effects only for DML like Update delete
and insert statements only,
for select statement we have to choose ExecuteScalar or
ExecuteReader methods. these methods can return datareader
and gives the result for your query.  |
| Sandyni |
| |
| |
| Question |
What is main five diffrent between Connected And
Disconnected environment |
Rank |
Answer Posted By |
|
Question Submitted By :: Ankit Kumar Singh |
| This Interview Question Asked @ Wipro , SATYAM |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Dataset is disconnected method where Datareader treated as
connected method.
Connected methods gives faster performance where as
disconnected get low in speed and performence.
connected can hold the data of single table, where as
disconnected can hold multiple tables of data.
Disconnected are the forward only and readonly objects
where as connected or not.  |
| Sandyni |
| |
| |
| Answer | connected data needs connection to be created to access
hence slower while disconnected is in memory data thats
faster access.
to access connected data you use ADO.NET whereas for
disconnected you do not use.
disconnected-data can be accessed from multiple tables in a
dataset.
connected- .net runtime creats an instance of the datatable
to hold data.
in disconnected data you can create a window to the
datatable in the form of a dataview used to sort and filter
data..which cannot be done in connected data access
connected you need to use a read only forward only data
reader,disconnected you cannot.
disconnected data in a dataset can be serialized/deserialized.  |
| Pratik |
| |
| |
| Answer | Data Reader:-
Data Reader is a read only and forward only data
You can access one table at a time.
Data reader cant persist the data.
Data Reader is connected architecture.
Data Reader is faster than Data Adapter
Data Reader is faster than dataset operation
Data Set:
Data Set is disconnected architecture.
Data Set is persist the data.
You can access more than one table
Data Set is main for storage tool in ADO.Net  |
| Chowdary |
| |
| |
| Answer | Data Reader is a forward only and read only data
DataSet is used to maintain relationships between multiple
tables.
Data Reader can't persist the data
Data Set can persist the data  |
| Varma |
| |
| |
| Question |
describe about the ado.net object model
|
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
| This Interview Question Asked @ TCS , Aaa |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | ADO object model includes five components.
They are:
SqlConnection Object,SqlCommand Object,SqlDataReader
object,Dataset object,SqlDataAdapter object.  |
| Priya |
| |
| |
| Answer | 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  |
| Prakash |
| |
| |
| Answer | 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.  |
| Sandyni |
| |
| |
| Question |
HOW TO FILL GRID VIEW WITH OUT USING SQLDATASOURCE AND
PROGRAMING?
|
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | SqlConnection conn = new SqlConnection("Data
Source=MYSERVER;Initial Catalog=Northwind;User
Id=sa;Password=sa;");
conn.Open();
DataTable dt=new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select
* from Employees", conn);
da.Fill(dt);
testGV.DataSource = dt;  |
| Manumole |
| |
| |
| Answer | Drag and drop the table on browser,difultly it shows grid
view ..  |
| Srikanth Chodavarapu |
| |
| |
| Answer | we can fill grid view by using sqldataadapter and dataset.
the code will be as follows........
using System.data.sqlclient (add namespace)
in code part....
sqlconnection con=new sqlconnection("server=(the server
which u use);database=(database in which your table
located);user id=;password=");
sqldataadapter da=new sqldataadapter("select * from
table",con);
dataset ds=new dataset();
da.fill(ds);
gridview1.datasourse=ds;
gridview1.databind();  |
| Sai_sanju84@yahoo.com |
| |
| |
| Question |
Why DataReader is Forward Only? |
Rank |
Answer Posted By |
|
Question Submitted By :: Amit Sharma |
| This Interview Question Asked @ NIIT |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Because it suppport the disconnected architecture :)  |
| Ankit |
| |
| |
| Answer | Data Reader worked as conventional Record Set of VB
and
Data Reader worked in connected mode only  |
| Lovely |
| |
| |
| Answer | Because it supported dissconnected architecture  |
| Deepak Rai |
| |
| |
| Answer | because it satisfy read only property from which we can only
retrieve data only(forword) not write to int(backword).  |
| Guneetinder Singh |
| |
| |
| Answer | DataReaader is connected object and one can process the
rows that are returned by query, one at a time. It discards
every row after you have gone through it and so it is
extremely fast.It contains only read-only data, so no
updates are allowed using DataReader
objects.  |
| Vrushali |
| |
| |
| Answer | datareader execute data from table one by one at each
calling of it.and to fetch next value from database it
contains pointer value(index) of next value . thats why if
is forward only. in the oops concept it works on the concept
of one-way linklist  |
| Rahul Singhal |
| |
| |
| Answer | A DataReader is a stream of data that is returned from a
database query. When the query is executed, the first row
is returned to the DataReader via the stream. The stream
then remains connected to the database, poised to retrieve
the next record. The DataReader reads one row at a time
from the database and can only move forward, one record at
a time. As the DataReader reads the rows from the database,
the values of the columns in each row can be read and
evaluated, but they cannot be edited.  |
| Manumole |
| |
| |
| Answer | As we know that DataReader is connected architecture it
cannot persists the contents. it reads the contents one by
one record from the dataset until all the records completed.
The main thing is data reader uses pointers to fetch the
next record(index).hence these are the forward only objects  |
| Sandyni |
| |
| |
| Answer | Because it supports connected architecture.  |
| Pawan |
| |
| |
| Question |
Difference between ADO and ADO.Net |
Rank |
Answer Posted By |
|
Question Submitted By :: Resh |
| This Interview Question Asked @ IBM , Innate |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | ADO has the recordset and connected archtecture where as
ADO.net has disconnected archtecture and DATASET  |
| Ankit |
| |
| |
| Answer | 1. ADO used connected data usage, while ADO.net used
disconnected data environment.
2. ADO used OLE DB to access data and is COM-based, while
ADO.net uses XML as the format for transmitting data to and
from your database and web application.
3. In ADO, Record set, is like a single table or query
result, while in ADO.net Dataset, can contain multiple
tables from any data source.
4. In ADO, it is sometime problematic because firewall
prohibits many types of request, while in ADO.net there is
no such problem because XML is completely firewall-proof.  |
| Guneetinder Singh |
| |
| |
| Answer | ADO is a com base library that supports only connected
data. This means that when we access the data (view, edit
and update) it is affected in real-time,since the
connection is being used all the time. ADO uses the objects
as reference data known as Recordset object. Hence it
basically gives a single table view of the data. We can
also join tables to create a new set of records in ADO.ADO
allows to create only client-side cursors. Using ADO we can
persist records in XML format and XML integration is not
possible.
ADO.NET is a CLR based library that supports disconnected
recordsets. This means that When we access data, ADO.NET
makes a copy of the data using XML and holds the connection
to pull down the data or to make any requested updates as
long as we need. The best method to follow is
ADO.NET.ADO.NET uses various objects known as Dataset that
allow to access data in various methods. Hence it allows to
store the relational model of the database and helps us to
access /update the data in each related table individually.
ADO.NET supports both client-side and server-side cursors.
Also the cursors are handled as classes in ADO.NET
providing a way to create efficient applications. Using
ADO.NET we can manupulate records in XML format. Also
ADO.NET 2.0 provides Multiple Active ResultSets (MARS)
which allows to have two datareader on one connection open
at sametime.  |
| Manumole |
| |
| |
| Answer | Following are some major differences between both
1.As in classic ADO we had client and server side cursors
they are no more present in ADO.NET. Note it's a
disconnected model so they are no more applicable.
2. Locking is not supported due to disconnected model.
3. All data persist in XML as compared to classic ADO where
data persisted in Binary format also.
4. Ado.net uses Dataset where as Ado uses RecordSet.
5.Ado.Net uses Dataproviders where as classic Ado uses COM
model.
6.Ado.net can able to works on multiple tables where as Ado
can works on only on etable.  |
| Sandyni |
| |
| |
| Question |
What is datatable? |
Rank |
Answer Posted By |
|
Question Submitted By :: Badmoon |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | The DataTable is an in-memory representation of a block of
data. We can create our own tables in code using a DataSet
and the types defined in the System.Data.OleDb or
System.Data.SqlClient namespaces. The following are the
core properties that are used while creating a DataTable.
CaseSensitive: Indicates whether string comparisons in
the table are case-sensitive or not.
ChildRelations: Returns the collection of child relations
of the DataTable (if any).
Columns: Returns the collection of columns that belong to
this table.
Constraints: Gets the constraints maintained by this table.
DataSet: Gets the dataset that contains this table.
DefaultView: Gets a customized view of the table that may
include a filtered view or a cursor position.
MinimumCapacity: Gets/Sets the initial number of rows in
the table.
ParentRelations: Gets the collection of parent relations
for this table.
PrimaryKey: Gets/Sets a primary key for the table.
Rows: Returns the collection of rows that belong to this
table.
TableName: Gets/Sets the name of the table.  |
| Badmoon |
| |
| |
| Answer | Datatable is a sql class which is used to create a temporary
table and working on it at run time.  |
| Guneetinder Singh [Home] |
| |
| |
| Answer | In ADO.NET, DataTable objects are used to represent the
tables in a DataSet.
A DataTable represents one table of in-memory relational
data; the data is local to the .NET-based application in
which it resides.
A DataTable is a collection of DataRow and DataColumn
objects.
The schema, or structure of a table is represented by
columns and constraints.
You define the schema of a DataTable using DataColumn
objects as well as ForeignKeyConstraint and
UniqueConstraint objects.  |
| Sandyni [Home] |
| |
| |
| Question |
how to display empty table to datagrid |
Rank |
Answer Posted By |
|
Question Submitted By :: Om Namo Bhagavathe Vasudevaya |
| This Interview Question Asked @ LG-Soft |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | DataTable tbl=new DataTable;
DataColumn ID=new
Datacolumn("ID",System.Type.GetType("System.Int"));
DataColumn Name=new
DataColumn("NAME",System.Type.GetType("System.String"));
tbl.Columns.add("ID");
tbl.Columns.Add("NAME");
Datarow dr =null;;
for (int i=0;i<100;i++)
{
dr=tbl.NewRow();
}
datagridview1.datasource=tbl;  |
| Dinesh Sharma |
| |
| |
|
| |
|
Back to Questions Page |